Thanks David...its working
On Mon, Mar 11, 2013 at 6:34 PM, David Grugeon wrote:
> This works
>
> Application.OnTime Now() + TimeValue("00:00:05"), Sheets("Test").CodeName
> & ".CommandButton1_Click"
>
> Regards
> David Grugeon
>
>
&
Waiting for reply..
On Mon, Mar 11, 2013 at 2:07 PM, Santosh V wrote:
> Please find the sample file attached.
>
>
> On Mon, Mar 11, 2013 at 1:41 PM, Abhishek Jain wrote:
>
>> A sample workbook would be helpful to understand better.
>>
>>
>> On Mon, Ma
Any one ???
On Mon, Mar 11, 2013 at 12:22 AM, Santosh V wrote:
> Be,
>
> Its not what i am looking for. Thanks for your respone.
>
>
>
> On Mon, Mar 11, 2013 at 12:14 AM, Bé Trần Văn
> wrote:
>
>> Use CommandButton1_Click to select sheet
>> Code:
Be,
Its not what i am looking for. Thanks for your respone.
On Mon, Mar 11, 2013 at 12:14 AM, Bé Trần Văn wrote:
> Use CommandButton1_Click to select sheet
> Code:
>
> Private Sub CommandButton1_Click()
> Sheets("TTLongThanh").Select
> End Sub
> See A
Private Sub CommandButton1_Click()
MsgBox "hi"
End Sub
Private Sub CommandButton2_Click()
Application.OnTime Now() + TimeValue("00:00:05"),
"Sheet1.CommandButton1_Click" ' It works
'Application.OnTime Now() + TimeValue("00:00:05"),
"Sheets('Test')!CommandButton1_Click"' It fails.
