Hello,

I want to chek user input on a page (index 1) of a multipage control as
soon as another page is selected. I have something like this:

Private Sub mpProcessData_Change()

If lngLastPage = 1 Then
If Not PageOK Then
Application.EnableEvents = False
mpProcessData.Value = 1
Application.EnableEvents = True
End If
End If
lngLastPage = mpProcessData.Value

End Sub

Apart from the fact that it does not work (only the tab is selected not the
page, regardless whether EnableEvent is enabled or not), I do not like it,
because I am forced to declare the global variable lngLastPage. Is there a
better way to do this?

TIA,

Arne

The tab is the page. Why does lngLastPage have to be global? Page indexes
start at 0 BTW.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Arne" wrote in message
...
Hello,

I want to chek user input on a page (index 1) of a multipage control as
soon as another page is selected. I have something like this:

Private Sub mpProcessData_Change()

If lngLastPage = 1 Then
If Not PageOK Then
Application.EnableEvents = False
mpProcessData.Value = 1
Application.EnableEvents = True
End If
End If
lngLastPage = mpProcessData.Value

End Sub

Apart from the fact that it does not work (only the tab is selected not
the
page, regardless whether EnableEvent is enabled or not), I do not like it,
because I am forced to declare the global variable lngLastPage. Is there a
better way to do this?

TIA,

Arne