Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
attach userform to button
I have this with statement
With Sheets("Agent Summary") ActiveSheet.OLEObjects.Add(ClassType:="Forms.Comma ndButton.1", Link:=False _ , DisplayAsIcon:=False, Left:=1.5, Top:=1, Width:=95.25, Height:= _ 24.75).Select Sheets("Agent Summary").CommandButton1.Caption = "Command Box" End With I want to attach a userform to the botton whe it creates teh button meaning I want the button to open a userform when its clicked after the button is created. Can I get help please? -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Browse and attach file in a UserForm | Excel Programming | |||
Mailto / Attach... Button to do so? | Excel Programming | |||
Mailto / Attach... Button to do so? | Excel Programming | |||
Mailto / Attach... Button to do so? | Excel Programming | |||
Mailto / Attach... Button to do so? | Excel Programming |