Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MultiPage control
Sorry posted this to the wrong group. Will move to the programming group
"Patrick Simonds" wrote in message ... 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 | |||
ActiveX control with chart | Charts and Charting in Excel | |||
How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
Create a tabular control | Excel Discussion (Misc queries) | |||
Tab to an ActiveX control? | Excel Discussion (Misc queries) | |||
Copying list-box control | Excel Discussion (Misc queries) |