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

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