Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select page tab when form opens
I have a form that has a number of pages on it.
How can I select which page to display when the form is opened? TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select page tab when form opens
sub userform_initialize()
with me multipage1("page1").enabled MultiPage1.Value = 1 MultiPage1("pageS1").txtClient.SetFocus end with end sub xxxxxxxxxxxxxxxxxx susan wrote: I have a form that has a number of pages on it. How can I select which page to display when the form is opened? TIA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select page tab when form opens
whoops......... page1's value would be 0.
wrote: I have a form that has a number of pages on it. How can I select which page to display when the form is opened? TIA |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select page tab when form opens
Susan wrote:
whoops......... page1's value would be 0. wrote: I have a form that has a number of pages on it. How can I select which page to display when the form is opened? TIA That hasn't worked for me :( I didn't want to use the initialize function - didnt explain my problem very well, I wanted different macros to open the form and display different pages e.g. Sub GoToHelp1() FrmHelp.show 'insert code here to display a particular page whent he form opens using this macro End sub |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select page tab when form opens
I get a run time error (438 Object does not support property or method)
when I use that snippet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opens to form then keep focus and unable to get to code - HELP!! | Excel Discussion (Misc queries) | |||
Load form when workbook opens | Excel Programming | |||
Load form when workbook opens | Excel Discussion (Misc queries) | |||
excel opens asp.net page | Excel Discussion (Misc queries) | |||
How do I set up an index page that opens other wkshts? | Excel Discussion (Misc queries) |