Grüezi akyhne

akyhne schrieb am 24.05.2004

I have 4 CommandButtons in a sheet. Each button opens the same form with
a multipage on it. Each CommandButton must open a specific page in the
multipage. I call my form like this:

MyForm.Show
MyForm.MultiPage1.Value = 3
DoEvents

The first time I click the CommandButton it opens the last used page in
the multipage instead of calling the page I want. If i close my form and
call it for the second time, using the same button, I get the page I
want!

Just define the Value of the multipage and show it then, so switch your
code-lines:

MyForm.MultiPage1.Value = 3
MyForm.Show

--
Regards

Thomas Ramel
- MVP for Microsoft-Excel -

[Win XP Pro SP-1 / xl2000 SP-3]