View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
George[_18_] George[_18_] is offline
external usenet poster
 
Posts: 4
Default Events for Controls in a Multipage Control

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