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.


--
kattes
------------------------------------------------------------------------
kattes's Profile: http://www.excelforum.com/member.php...o&userid=24003
View this thread: http://www.excelforum.com/showthread...hreadid=376234

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

Robin Hammond
www.enhanceddatasystems.com

"kattes" wrote in
message ...

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.


--
kattes
------------------------------------------------------------------------
kattes's Profile:
http://www.excelforum.com/member.php...o&userid=24003
View this thread: http://www.excelforum.com/showthread...hreadid=376234

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

--
katte
-----------------------------------------------------------------------
kattes's Profile: http://www.excelforum.com/member.php...fo&userid=2400
View this thread: http://www.excelforum.com/showthread.php?threadid=37623

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

"kattes" wrote in
message ...

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

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

but outside multipage, everything works normal.
:(


--
kattes
------------------------------------------------------------------------
kattes's Profile:
http://www.excelforum.com/member.php...o&userid=24003
View this thread: http://www.excelforum.com/showthread...hreadid=376234