Setfocus + show a page

[ducecoop]

Excel 2003
User form
coding an If statement
the "Else"
FieldName.Setfocus

The User form has a MultiPage object
in addition to the above (setfocus) in a particular field (NOT on the MultiPage object) I want it open to Page2 instead of what ever page it was last closed on.

I tried this:
MultiPage1.Page2.Enabled

but no go

any suggestions

Any help here will be appreciated.

Thanks in advance
Duce

[Leith Ross]

Hello ducecoop,

Try this ....

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[ducecoop]

Hello ducecoop,

Try this ....

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Thank you - That worked