View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Events for Controls in a Multipage Control

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



.