PC Review


Reply
Thread Tools Rate Thread

Control Hierarchies in Userforms

 
 
=?Utf-8?B?RXhjZWxNb25rZXk=?=
Guest
Posts: n/a
 
      20th Apr 2007
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Codes to Control Flow Among Multiple Userforms Kabirch Webmaster / Programming 1 29th Jun 2009 12:50 PM
Control arrays on Excel 2007 userforms Informative Microsoft Excel Misc 1 26th Feb 2008 09:36 PM
Set Focus on Control at Creation in Dialogs, I mean UserForms GJones Microsoft Excel Programming 0 4th May 2004 02:15 PM
Re: Hierarchies Lowland Microsoft Windows 2000 New Users 0 8th Aug 2003 02:08 PM
Re: Hierarchies Carrie Garth \(MVP\) Microsoft Windows 2000 New Users 0 6th Aug 2003 01:01 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:19 PM.