Help with Multipage Events

[kattes]

Hi all,
I am stuck in a bad way, dunno if i am doing anything wrong.

I was trying in excel 2002 to include a multipage with 2 pages in it. I
added controls to it in edit mode. controls included labels, textboxes,
and buttons.

Now i dont know how to register the click event of the button inside
the multipage, or say the change event of the textbox inside the
multipage.

In edit mode, I clicked the button several times, but it does not go to
the code mode at all, all it does is that it goes for multipage events
only, not the events of the controls inside the multipage, please help
me.

Imagine that you have a user form with controls, if you drag and drop a
button and doubleclick, you go to the commandbutton1_Click() method in
code mode to add functionality. but if the button is inside a page of a
multipage, this is not happening. This is what I meant.

 

[Robin Hammond]

Get Rob Bovey's code cleaner and clean your project. That should do it.

Robin Hammond
www.enhanceddatasystems.com

 

[kattes]

Hey thanks, that seems to be a nice add-in. But still no go. its no
working. For this, I created a new excel file on another computer wit
only a form, a multipage and a command button on page 1 of th
multipage. still i am not able to register the click event of th
command button on the multipage as we do on a userform.

not only the command button, but any event of any control inside th
multipage.

but outside multipage, everything works normal.
:

 

[Robin Hammond]

Kattes,

Sorry it didn't work. That usually clears things up for me when controls
stop behaving correctly. No further suggestions I'm afraid.

Robin Hammond
www.enhanceddatasystems.com