Select Multipage by name?
 

I have a multipage on a form with one particular page named "p13". Can I
select that page by its name "p13"?

Excel 2003.

--
|
+-- Julian
|

Select Multipage by name?
 

No you use the value property of the multipage.
Me.MultiPage1.Value = 0 'Page 1


--
Regards Ron de Bruin
http://www.rondebruin.nl




"Julian" wrote in message ...
I have a multipage on a form with one particular page named "p13". Can I select that page by its name "p13"?

Excel 2003.

--
|
+-- Julian
|

Select Multipage by name?
 

But maybe you want this for a page named "ron" (Name not caption)

Me.MultiPage1.Value = Me.MultiPage1.Pages("ron").Index


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ron de Bruin" wrote in message ...
No you use the value property of the multipage.
Me.MultiPage1.Value = 0 'Page 1


--
Regards Ron de Bruin
http://www.rondebruin.nl




"Julian" wrote in message ...
I have a multipage on a form with one particular page named "p13". Can I select that page by its name "p13"?

Excel 2003.

--
|
+-- Julian
|

Select Multipage by name?
 

You could use something like:

With Me.MultiPage1
.Value = .Pages("p13").Index
End With

You did mean the name, not the caption, right?


Julian wrote:

I have a multipage on a form with one particular page named "p13". Can I
select that page by its name "p13"?

Excel 2003.

--
|
+-- Julian
|

--

Dave Peterson

Select Multipage by name?
 

Dave & Ron,

That's exactly what I was after, a bit long winded but useful.

FYI, I thought that if you could do:

Range("MyNamedRange").Select

Then it seems strange that you can't do the same with Multipages. LoL


--

|
+-- JDMils
|

"Dave Peterson" wrote in message
...
You could use something like:

With Me.MultiPage1
.Value = .Pages("p13").Index
End With

You did mean the name, not the caption, right?


Julian wrote:

I have a multipage on a form with one particular page named "p13". Can I
select that page by its name "p13"?

Excel 2003.

--
|
+-- Julian
|

--

Dave Peterson