hi

i need some help with events for a control

i have a multipage control, to which i add controls

however i am unable to write code for them

is there a way to do this ?

ie
in the general, i delcare

Public WithEvents cFoo As CommandButton

then in a macro

set foo = MultiPage1.Pages(0).Controls.Add
("Forms.CommandButton.1","cmdMain",True")

how do i write an event for this object

or how do i manuall add on object in design mode and add
code for the event

any help would be appreiciated, thanks

-George

Not on a worksheet - which is what I assume you are trying to do.

--
Regards,
Tom Ogilvy


"George" wrote in message
...
hi

i need some help with events for a control

i have a multipage control, to which i add controls

however i am unable to write code for them

is there a way to do this ?

ie
in the general, i delcare

Public WithEvents cFoo As CommandButton

then in a macro

set foo = MultiPage1.Pages(0).Controls.Add
("Forms.CommandButton.1","cmdMain",True")

how do i write an event for this object

or how do i manuall add on object in design mode and add
code for the event

any help would be appreiciated, thanks

-George

the multipage control is embedded in a worksheet


-----Original Message-----
Not on a worksheet - which is what I assume you are
trying to do.

--
Regards,
Tom Ogilvy


"George" wrote in message
...
hi

i need some help with events for a control

i have a multipage control, to which i add controls

however i am unable to write code for them

is there a way to do this ?

ie
in the general, i delcare

Public WithEvents cFoo As CommandButton

then in a macro

set foo = MultiPage1.Pages(0).Controls.Add
("Forms.CommandButton.1","cmdMain",True")

how do i write an event for this object

or how do i manuall add on object in design mode and add
code for the event

any help would be appreiciated, thanks

-George


.

and you had to go to more controls to get it there - the reason is that it
isn't supported on a worksheet - you can plunk it down there, but you can't
have events for the controls placed on it - at least I have never figured
out how to do it and have never seen any one else post a method. (although
the topic doesn't come up very often).

--
Regards,
Tom Ogilvy


"George" wrote in message
...
the multipage control is embedded in a worksheet


-----Original Message-----
Not on a worksheet - which is what I assume you are
trying to do.

--
Regards,
Tom Ogilvy


"George" wrote in message
...
hi

i need some help with events for a control

i have a multipage control, to which i add controls

however i am unable to write code for them

is there a way to do this ?

ie
in the general, i delcare

Public WithEvents cFoo As CommandButton

then in a macro

set foo = MultiPage1.Pages(0).Controls.Add
("Forms.CommandButton.1","cmdMain",True")

how do i write an event for this object

or how do i manuall add on object in design mode and add
code for the event

any help would be appreiciated, thanks

-George


.

I am trying to do the same thing except I am not creating the multipage control in a spreadsheet but in a form. I want to add controls to new pages on the multipage control at run time. I can't figure out how to created events for the new controls. I am not accessing the spreadsheet at all

----- Tom Ogilvy wrote: ----

and you had to go to more controls to get it there - the reason is that i
isn't supported on a worksheet - you can plunk it down there, but you can'
have events for the controls placed on it - at least I have never figure
out how to do it and have never seen any one else post a method. (althoug
the topic doesn't come up very often)

--
Regards
Tom Ogilv


"George" wrote in messag
..
the multipage control is embedded in a workshee
-----Original Message----
Not on a worksheet - which is what I assume you ar
trying to do
--
Regards
Tom Ogilv
"George" wrote in messag
..
h
i need some help with events for a contro
i have a multipage control, to which i add control
however i am unable to write code for the
is there a way to do this
i
in the general, i delcar
Public WithEvents cFoo As CommandButto
then in a macr
set foo = MultiPage1.Pages(0).Controls.Ad
("Forms.CommandButton.1","cmdMain",True"
how do i write an event for this objec
or how do i manuall add on object in design mode and ad
code for the even
any help would be appreiciated, thank
-Georg