| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 97 VBA: Multipage set focus method
I can't work out how to set the focus on a particular page
of a multipage control. MultiPage1.SetFocus The above gives the whole page control the focus but I want to select Page1 in particular. Many thanks David |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 97 VBA: Multipage set focus method
David,
Use the Value property. A Value of 0 is the first page, 1 is the second page, and so on. E.g., Me.MultiPage1.Value = 0 ' go to page 1 -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "David" wrote in message ... I can't work out how to set the focus on a particular page of a multipage control. MultiPage1.SetFocus The above gives the whole page control the focus but I want to select Page1 in particular. Many thanks David |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 97 VBA: Multipage set focus method
Multipage1.Value = 0
makes the first page the visible page. The page numbers are zero based. Assume that is what you are asking. -- Regards, Tom Ogilvy "David" wrote in message ... I can't work out how to set the focus on a particular page of a multipage control. MultiPage1.SetFocus The above gives the whole page control the focus but I want to select Page1 in particular. Many thanks David |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 97 VBA: Multipage set focus method
That's perfect. Thanks Chip
-----Original Message----- David, Use the Value property. A Value of 0 is the first page, 1 is the second page, and so on. E.g., Me.MultiPage1.Value = 0 ' go to page 1 -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please post this thread a correct full method, method about | New Users to Excel | |||
| Please post this thread a complete correct method, method about te | New Users to Excel | |||
| Embedding multipage word documents into excel | Excel Discussion (Misc queries) | |||
| cursor focus in excel | Excel Discussion (Misc queries) | |||
| How do I get focus back on an Excel file? | Charts and Charting in Excel | |||
Linear Mode
