| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
r/t 2110 - Can't Move Focus to control
I have Userform1 with 3 pages
On My page1 I have TextBox1 inside Frame1 Once I enter all data covering the 3 pages and I update my database I want in the next line of code to RETURN (set focus) to my Page1 - Textbox1 Currently using: (but it is not working) - What must I do? UserForm1.Page1.TextBox1.SetFocus |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
r/t 2110 - Can't Move Focus to control
Never mind, Found googling:
Me.MultiPage1.Value = 0 TextBox1.SetFocus Now works fine!! "JMay" wrote: I have Userform1 with 3 pages On My page1 I have TextBox1 inside Frame1 Once I enter all data covering the 3 pages and I update my database I want in the next line of code to RETURN (set focus) to my Page1 - Textbox1 Currently using: (but it is not working) - What must I do? UserForm1.Page1.TextBox1.SetFocus |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VB Control Focus | Excel Programming | |||
| Move cell focus in VBA | Excel Programming | |||
| setfocus sometimes gets error 2110 | Excel Programming | |||
| Set Focus Problem for textbox control on multipage control | Excel Programming | |||
| 3 digits then move the focus | Excel Programming | |||
Hybrid Mode
