Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control Hierarchies in Userforms
I have a userform (Userform1) which has a multipage control (Mulitpage1) on
it. I then have several pages in this multipage control. On the first page I hava a combobox(ComboBox1). When I have using a With End stmt I can call up the following: With ComboBox1 or With Userform1.ComboBox1 or Userform1.Multipage1 However, I cannot drill down to the page that the combobox is on: Userform1.Multipage1.Page(1).Combobox1 or whatever is equivalent. Why is this? The reason I want to do this is that I will have a lot of controls spread around multiple pages. It would be helpful to see the full heirarchy in the with stmtm. I guess otherwise I will have to name the control with this information to get around this. Thanks EM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
Control arrays on Excel 2007 userforms | Excel Discussion (Misc queries) | |||
Formatting Attribute Hierarchies | Excel Discussion (Misc queries) | |||
Calendar Control: Can't exit design mode because control can't be created | Excel Programming | |||
Set Focus on Control at Creation in Dialogs, I mean UserForms | Excel Programming |