View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey ExcelMonkey is offline
external usenet poster
 
Posts: 553
Default 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