Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default activating a page of a multipage control

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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default activating a page of a multipage control

The tab (#1) is activated alright, but not the page 'attached' to it. So,
the problem remains


I have no idea what you mean by that.

Declare it as Static and it won't.

--
---
HTH

Bob


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



"Arne" wrote in message
...


"Bob Phillips" wrote:

The tab is the page. OK, fine, but how do I get the page that corresponds
to the tab displayed? The tab (#1) is activated alright, but not the page
'attached' to it. So, the problem remains


Why does lngLastPage have to be global? Because it would go out of scope
if
it were defined in the Event sub? The scope of that variable therefore has
to
be the module of the form on which the multipage is displayed, I think(?)

Page indexes
start at 0 BTW. I know, 1 was an arbitrary number.

--
---
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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MultiPage control Patrick Simonds Excel Worksheet Functions 1 August 5th 06 05:32 PM
change font color whenever click a page of multipage control tom taol Excel Programming 0 October 12th 05 10:45 PM
Looking for eloquent solution: Determine of any control on a page of multipage has been altered (userform) KR Excel Programming 0 December 13th 04 09:04 PM
Set Focus Problem for textbox control on multipage control ExcelDeveloperSPR Excel Programming 1 July 16th 04 08:54 PM
hide a page on a multipage control Spencer Hutton[_2_] Excel Programming 1 April 22nd 04 02:07 PM


All times are GMT +1. The time now is 03:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"