How to check for active sheet in Multipage on a Userform

L

Lasse

Hi

I am creating a Userform in Word 2007 and have added a multipage with 3
sheets. I have created a Multipage_Change procedure that runs some code when
change between the sheets.
How can I see which of my 3 sheets thats the active one when running the
Multipage_Change?

/Lasse
 
J

Jonathan West

Lasse said:
Hi

I am creating a Userform in Word 2007 and have added a multipage with 3
sheets. I have created a Multipage_Change procedure that runs some code
when
change between the sheets.
How can I see which of my 3 sheets thats the active one when running the
Multipage_Change?
Click to expand...

The Value property of the multipage control gives you the active page number
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
Convert old wordbasic code into VBA that will run now 0
Testing whether a page in MultiPage is active 1
Stay on Active Sheet 2
Removing the header of a UserForm in Word 2007 4
Dump ListBox Contents to Sheet & Stay on Active Sheet 0
MultiPage 2
Changing page height while in a multipage 2

Top