Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MultiPage Form Question NFL Excel Discussion (Misc queries) 4 December 30th 09 02:21 PM
Multipage Part of Form Bill[_30_] Excel Programming 3 June 30th 06 02:34 PM
Color in Multipage Form Gian Excel Programming 2 August 24th 05 03:56 PM
multipage form Sandy Excel Programming 1 May 6th 05 07:47 AM
Multipage & Spinbutton controls on a form Bhuktar S Excel Programming 1 April 21st 04 01:50 PM


All times are GMT +1. The time now is 11:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"