Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MultiPage control
I asked a question about MultiPage control and had intended to make it a 2
parter, so here is part 2. My UserForm has a MultiPage control on it. I open the UserForm with the code below. Now I have 3 different worksheets and they each get their data from a different Page on the MultiPage control. What I want to know is if the code below could be altered in any way as to determine which page of the MultiPage control has focus when the UserForm is opened? So lets say if line 1 of the code below were to call the UserForm Page 1 of the MultiPage control would have focus, but of line 2 were to call the UserForm then Page 3 of the MultiPage control would have focus. If Not Application.Intersect(Target, Range("E7:E11")) Is Nothing Then Data_Input.Show If Not Application.Intersect(Target, Range("E22")) Is Nothing Then Data_Input.Show |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multipage control | Excel Programming | |||
Set Focus Problem for textbox control on multipage control | Excel Programming | |||
MultiPage Control | Excel Programming | |||
MultiPage control | Excel Programming | |||
Multipage control | Excel Programming |