View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
llowwelll llowwelll is offline
external usenet poster
 
Posts: 1
Default Add Controls With Events at Runtime

I want to be able to add controls to a VBA worksheet at runtime and the
be able to handle them with events. How do I do this?

Specifically, my application automatically queries a constantl
changing Access database every five minutes. The records from th
query are then displayed on an Excel worksheet. There is one row fo
each record. What I need to do is add a couple of command buttons an
a label to each row/record. If the user clicks on one of the button
or labels added at runtime, I need to be able to respond to this wit
code.

Thanks very much in advance for any help or advice that you ca
provide!

--
Message posted from http://www.ExcelForum.com