View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arne Arne is offline
external usenet poster
 
Posts: 35
Default activating a page of a multipage control

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