Solved

VBA - Word, Toggle Show/hide Multipages in Userform

Posted on 2015-01-07
7
330 Views
Last Modified: 2015-01-07
Hi guys,

I'm quite new at VBA, and working on a big project with a word document and vba.

I need some help with being able to toggle a multipage show/hide. I have gotten this far that i'm able to toggle it to show but not the other way around.

please help,

this is the code i'm using:

Me.MultiPage1.Pages(2).Visible = True

Open in new window

0
Comment
Question by:Hakum
  • 4
  • 3
7 Comments
 
LVL 49

Expert Comment

by:Rgonzo1971
ID: 40535685
Hi

if you want to hide the second page do use 1 (zero based)

Me.MultiPage1.Pages(1).Visible = False

Regards
0
 
LVL 1

Author Comment

by:Hakum
ID: 40535706
I want to unhide the 3rd and onwards pages depending on if its checked in diffrent checkboxs on page 2

View the attachment for the doc im working with at the moment
0
 
LVL 49

Expert Comment

by:Rgonzo1971
ID: 40535709
No file
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 1

Author Comment

by:Hakum
ID: 40535711
0
 
LVL 1

Author Comment

by:Hakum
ID: 40535719
try now :) something went wrong
0
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40535733
Hi,

pls try

Private Sub CheckBox14_Click()

'On/Off Toggle
Dim ctrl As Control

    For Each ctrl In Me.Frame15.Controls
        ctrl.Enabled = Not (ctrl.Enabled)
    Next

Me.MultiPage1.Pages(2).Visible = CheckBox14.Value

End Sub

Open in new window

And so on...

Regards
0
 
LVL 1

Author Closing Comment

by:Hakum
ID: 40535751
YOU ROCK!!! THANKS A TON!! :D
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
My experience with Windows 10 over a one year period and suggestions for smooth operation
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now