There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Software Development
Tag Cloud
audio blue screen boot bsod computer cpu crash dell desktop driver drivers error excel external hard drive firefox firewall freezes freezing hard drive hardware hijackthis internet internet explorer itunes laptop malware motherboard mouse network networking outlook outlook 2007 popups power printer problem ram router screen slow sound trojan usb virus vista vista 32-bit windows windows xp winxp wireless
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Software & Hardware > Software Development >
VBA Multipage Display


Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members. Enjoy!

Closed Thread
 
Thread Tools
jillianbk's Avatar
Junior Member with 18 posts.
 
Join Date: Jul 2003
06-Aug-2003, 02:38 PM #1
Post VBA Multipage Display
I have a user form that contains three multipages on it. I want the first multipage to always be displayed when the user opens the user form. Right now the multipage the user displayed just before they close the page is the one displayed upon opening again. Does anyone know how to go about doing this?

jillianbk
SabreWolf3's Avatar
Senior Member with 227 posts.
 
Join Date: Nov 2000
Location: Washington, DC
07-Aug-2003, 01:45 PM #2
Hi Jillianbk,

What you need to do is to is to set the 1st page object in view before you show your UserForm.

In your code, right before you display the UserForm, enter this line:

UserForm1.MultiPage1.Value = 0

This will always make the first page in the MultiPage control be displayed. Of course, if your UserForm is not named "UserForm1", you must change that part to match the name of your UserForm. The same goes with the MultiPage control. If your is MultiPage2, then change that part as well.

Regards,
Richard
__________________
If I have helped you, please donate to help keep the site FREE
jillianbk's Avatar
Junior Member with 18 posts.
 
Join Date: Jul 2003
07-Aug-2003, 03:45 PM #3
thank you richard!
Closed Thread

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.



Thread Tools


You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 03:02 AM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.