Thread: TextBox Focus
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Wilson John Wilson is offline
external usenet poster
 
Posts: 550
Default TextBox Focus

Wondering if this is possible (it's giving me an error).

On a UserForm
I have Frame1 with TextBox1 in it.
I have Frame2 with TextBox2 in it.

How can I set focus to TextBox2 in the AfterUpdate event for TextBox1??
Frame2.TextBox2.SetFocus ' doesn't work
TextBox2.SetFocus ' doesn't work

Setting the Tab order doesn't work either.

Any ideas??

Thanks,
John