Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MultiPage Form
Two questions. I have a label on one of the pages and I want to create a
click_event that will open another form. What is the syntax for this? And then the pages I am creating are very long. I found some code that allows a vertical scroll bar when the form is Run, but I can't seem to figure out how to scroll down on the form in design mode. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MultiPage Form
On Apr 7, 6:28*am, SoNew2This
wrote: Two questions. I have a label on one of the pages and I want to create a click_event that will open another form. What is the syntax for this? And then the pages I am creating are very long. I found some code that allows a vertical scroll bar when the form is Run, but I can't seem to figure out how to scroll down on the form in design mode. A1. Try the following code from eventhandler of the button to open another form: FormNameOtherForm.Show Can you please elaborate what you want to do in the second problem? Anant |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MultiPage Form
I have created a Userform and placed a number of frames on the form. Mainly
to seperate the different like areas. If I am in the View-Object (UserForm1) there are no scroll handles on the form. The only way to see what is below is to change the Zoom to a value less that 100, but then I still can't get the focus on a lower area and zoom it back up to work on it. Hope this makes more sense " wrote: On Apr 7, 6:28 am, SoNew2This wrote: Two questions. I have a label on one of the pages and I want to create a click_event that will open another form. What is the syntax for this? And then the pages I am creating are very long. I found some code that allows a vertical scroll bar when the form is Run, but I can't seem to figure out how to scroll down on the form in design mode. A1. Try the following code from eventhandler of the button to open another form: FormNameOtherForm.Show Can you please elaborate what you want to do in the second problem? Anant |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MultiPage Form Question | Excel Discussion (Misc queries) | |||
Multipage Part of Form | Excel Programming | |||
Color in Multipage Form | Excel Programming | |||
multipage form | Excel Programming | |||
Multipage & Spinbutton controls on a form | Excel Programming |