View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brotha Lee Brotha Lee is offline
external usenet poster
 
Posts: 43
Default add event to controls added in runtime

Hi,

I can not figure this out!

Does anybody knows how you can add events to controls added in runtime on a
userform.

I use the following code to:

myheight = 12
mytop = 70
mywidth = 12
myleft = 12
Set Mycmd = Controls.Add("Forms.CommandButton.1", "Test")
Mycmd.Left = myleft
Mycmd.Top = mytop
Mycmd.Width = mywidth
Mycmd.Height = myheight