Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pages on userform
Hi all
I am using the multipage option on a userform. It has 8 pages in it and I would like to have the names of each page to represent a certain cell value. Is this possible? Thanks Greg |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pages on userform
Greg,
This assumes page labels in first sheet first column. Private Sub UserForm_Initialize() Dim lCounter As Long With MultiPage1 For lCounter = 0 To .Pages.Count - 1 .Pages(lCounter).Caption = Sheets(1).Cells(lCounter + 1, 1) Next lCounter End With End Sub Robin Hammond www.enhanceddatasystems.com "Greg" wrote in message ... Hi all I am using the multipage option on a userform. It has 8 pages in it and I would like to have the names of each page to represent a certain cell value. Is this possible? Thanks Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number of pages in worksheet doesn't match Print Preview pages | Excel Discussion (Misc queries) | |||
How do I delete pages in Excel? Keeps printing blank pages at end. | Charts and Charting in Excel | |||
Need Help -- Baseball stats in excel only has 23 pages--Need to addmore pages.. | Setting up and Configuration of Excel | |||
Need Help -- Baseball stats in excel only has 23 pages--Need to addmore pages... | Excel Worksheet Functions | |||
How do I delete pages from an Excell template of mutiple pages | Excel Discussion (Misc queries) |