t;
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
>> *Sent:* Sunday, January 29, 2012 9:41 AM
>> *To:* excel-macros@googlegroups.com
>>
>> *Subject:* Re: $$Excel-Macros$$ about set focus ev
*Sent:* Sunday, January 29, 2012 9:41 AM
> *To:* excel-macros@googlegroups.com
>
> *Subject:* Re: $$Excel-Macros$$ about set focus event
>
> ** **
>
> Dear Shankar,
>
>
>
> Please see attached sheet..
>
>
>
> Private Sub TextBox1_Ch
-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ about set focus event
Dear Shankar,
Please see attached sheet..
Private Sub TextBox1_Change()
If Len(TextBox1) = 2 Then
TextBox2.SetFocus
End If
End Sub
Private Sub TextBox2_Change()
If Len(TextBox2) = 2 Then
Thanks for posting a useful, practical application, Noorain.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Sunday, January 29, 2012 9:41 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ about set focus event
Behalf Of *Asa Rossoff
>> *Sent:* Friday, January 27, 2012 11:47 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* RE: $$Excel-Macros$$ about set focus event
>>
>> ** **
>>
>> Hello Shankar,
>>
>> If you mean a SetFocus metho
> excel-macros@googlegroups.com] *On Behalf Of *Asa Rossoff
> *Sent:* Friday, January 27, 2012 11:47 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* RE: $$Excel-Macros$$ about set focus event
>
> ** **
>
> Hello Shankar,
>
> If you mean a SetFocus met
e not fired.)
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Friday, January 27, 2012 11:47 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ about set focus event
Hello Shankar,
If you mean a SetFocus m
Hello Shankar,
If you mean a SetFocus method, form and ActiveX controls have that in Excel.
If you mean a GotFocus event, ActiveX controls have that and you can use
them in Excel.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shankar Bheema
Se