Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


VB Excel 2003 Multipage Control

Posted on 2011-10-20
Medium Priority
Last Modified: 2012-06-21
I have a form that has a multipage control on it.  I would like to have it return to the page where the user left off when the form is loaded.  I thought it would be simple enough to have a value in a cell of the spreadsheet store the page number each time the user clicked on a page then when the form reloads it uses that number to select that page.  I have not been able to figure out how to get the page number to the cell I want when the user clicks the page.
The loading of the form and selecting the page from a stored value in a cell is no problem.
Question by:DavidH7470
LVL 77

Accepted Solution

GrahamSkan earned 2000 total points
ID: 37002113
Try it like this:
Option Explicit
Private Sub MultiPage1_Change()
    Sheets(1).Cells(1, 1).Value = MultiPage1.Value
End Sub

Private Sub UserForm_Initialize()
    MultiPage1.Value = Val(Sheets(1).Cells(1, 1).Value)
End Sub

Open in new window


Author Closing Comment

ID: 37002555
Prefect thanks

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

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

With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
I came across an unsolved Outlook issue and here is my solution.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

575 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