| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to insert subform in main form in excel 2003
How to make subform in main form in excel 2003 using VBA excel only?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to insert subform in main form in excel 2003
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--- -- RyGuy "Andi" wrote: How to make subform in main form in excel 2003 using VBA excel only? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to insert subform in main form in excel 2003
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... "ryguy7272" wrote: 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--- -- RyGuy "Andi" wrote: How to make subform in main form in excel 2003 using VBA excel only? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to insert subform in main form in excel 2003
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" ..... -- Cheers, Ryan "Andi" wrote: 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... "ryguy7272" wrote: 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--- -- RyGuy "Andi" wrote: How to make subform in main form in excel 2003 using VBA excel only? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pass value to form to subform to subform | Excel Programming | |||
| User Form texbox insert text in cell - excel 2003 | Excel Programming | |||
| form/subform with buttons | Excel Worksheet Functions | |||
| Using one subform to control another subform | Excel Programming | |||
| 2nd Form deselects list box items on main form | Excel Programming | |||
Linear Mode
