View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
onedaywhen onedaywhen is offline
external usenet poster
 
Posts: 459
Default Can't dynamically add withevents OptionButton to worksheet

Dick,
First off, thank you so much for spending the considerable time and
effort on this issue for me, definitely above and beyond. Second, you
got a result where I failed and, although I'm not surprised - you MVPs
are something else - I certainly am impressed.

In answer to your questions, I will end up using this approach in my
solution if I can successfully change the delay to
TimeValue("00:00:01") - I need to test for timing issues - and decide
that even a one second delay is acceptable to my application.

Did I learn something new? I was about to say, "Not really..." but I
quickly checked myself. I knew how to add optionbuttons
programmatically and I knew I could subclass (is that the right
expression?) optionbuttons that had been added manually. But I was
about a million miles away from making the leap required to try
connecting the two separate routines with Application.OnTime. Thanks
to you, though, next time I may make that leap.

Thanks again.

"Dick Kusleika" wrote in message ...

<snip

and it works. Now I have a headache. Let me know what you end up doing or
if you learn anything new.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.