MultiPage - UserForm Object - Accessing sub objects 1

[hafod]

Hi
I am having difficult programatically accessing - and therefore being able to change the properties of this type of object - and objects placed on each of two 'pages'within it.

For example, frmCommentsTargets is the UserForm:
frCommentTargets is a frame on the form. The multipage object within the frame is pgCommentsTargets and the 'pages' are named the 'pgComments' and 'pgTargets'. I cannot access the latter or their objects which are associated text boxes.

frmDataEntry.frCommentsTargets.pgCommentsTargets.(... no multipage objects/properties appear beyond this except for the properties of the multipage itself - move backcolour etc)

Am I using the object model correctly? I would like to access the text boxes on the two multipage 'pages' and be able to show the correct tab focus in the main body program.

Many thanks in anticipation of sonme help
Mike

 

[TonyJollans]

Hi Mike,

Can you not just reference [blue]frmDataEntry.TextBox[/blue]? - all the objects on the Form should have unique names and all the qualification should not be needed (and, as you see, isn't possible).

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[hafod]

Hi Tony,
Many thanks for post. Perhaps I was overcomplicating things (big time)trying to use the object model. Yes, suggestion works fine.
Many thanks,
Mike