View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
donbowyer[_2_] donbowyer[_2_] is offline
external usenet poster
 
Posts: 1
Default how to access programatically added controls

Thanks to both Dave & Jim. That is the conclusion I came
to - keep it simple! I will look at John's site for
OptionButtons though. Cheers
Don
-----Original Message-----
John Walkenbach has an example using OptionButtons at:
http://j-walk.com/ss/excel/tips/tip76.htm

But as an alternative, couldn't you design your form with

that button already on
there--just have it not visible. Then when/if you need

it, show it. (seems
much easier to me).

don bowyer wrote:

I have a UF to which some code adds a CommandButton in
runtime. No problem. But in design mode, by defenition,
the added control doesn't exist. So where do I put code

to
recognise and act upon its click event. I've run out of
inspired guesses. Any help would be appreciated.
Don


--

Dave Peterson

.