Posted to microsoft.public.excel.programming

Memphis[_2_] Memphis[_2_] is offline

external usenet poster

Posts: 6

Changing page height while in a multipage

It worked like a charm, thank you Peter ;-)

Memphis.
______________

"Peter T" wrote:

' in the user form module

Private Sub MultiPage1_Change()
With MultiPage1
If .Value = 2 Then
.Height = 200
Else
.Height = 400
End If
End With
End Sub

Note the index of the first page is 0, assuming Page3 is the 3rd page its
index is 2

Regards,
Peter T

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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 - default to particular page	Clayman	Excel Programming	3	June 25th 07 03:08 PM
need to dbl row height without changing height of cell next to it	Excel-Illiterate	New Users to Excel	1	May 16th 06 01:08 AM
How do I set the focus to a page in a multipage	Azza	Excel Programming	2	November 23rd 04 10:42 PM
MultiPage scripted changing	Alejandro[_3_]	Excel Programming	1	June 16th 04 05:36 PM
how to put a reference from a page of a multipage form to another page	Valeria[_2_]	Excel Programming	2	January 25th 04 08:21 AM

All times are GMT +1. The time now is 07:28 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us