How to insert subform in main form in excel 2003

R

ryguy7272

I am pretty sure you are referring to Access UserForms, not Excel UserForms.
Have you considered posting over at the Access Forms ares?


Regards,
Ryan---
 
A

Andi

Thanks,
But that not the right one I'm looking for.
in excel, i try to write vba program with visual basic, but seem only one
form. so i need to know how to put sub-form into the main form like in the
access.
thanks...
 
R

RyanH

You want the MultiPage Control. The MultiPage Control should be on your
toolbox toolbar in the VB Editor. The Multipage control you add onto your
original Userform at design time.

Note: Each page of the MultiPage Control is considered an object and you
need to reference it like so:

'first page
Me.MultiPage1.Pages(0)...
'second page
Me.MultiPage1.Pages(1)...

Hope this helps! If you please click "Yes"
.....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Main form/Subform Navigation 0
[XL2003] get results from a subform back to the main form 2
mirror data from subform to main form 3
mirror data from subform to main form 0
Access Daily Entry with multiple entries per field 0
Excel application main window background 3
Access Manage Attachments linked to a SubForm 0
Update subform with combobox change on main form 1

Top