Add Controls at Runtime with Events

Giganews Newsgroups
Subject: Add Controls at Runtime with Events
Posted by:  llowwelll (llowwel…
Date: Tue, 18 May 2004

I need to add a series of controls at runtime in Excel that I can interact
with via events.  How do I do this?

Specifically, my program automatically queries a database every five
minutes to update it's information.  The information is constantly
changing.  For each record in the database, the program creates a row of
info on an Excel worksheet.  I want to be able to create a command button
and label for each record on the worksheet.  How would I accomplish this?

Thanks in advance!