| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Command button Conditionally
Hey guys
I have a userform. On this form are various objects. One them is Frame7 and OptionButton3. What I would like is when a user clicks OptionButton3, a command button is created and inserted in Frame7. I need for it to be located and positioned in the frame at 283 Top and 156 left. I need the dimensions of the button to be 18 height and 78 width. Is this possible to do? Thank you Todd Huttenstine |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating Command button Conditionally
The easiest would be to put it where you want it manually, then make it not
visible in properties. In the click event of the optionbutton, make it visible -- Regards, Tom Ogilvy Todd Huttenstine wrote in message ... Hey guys I have a userform. On this form are various objects. One them is Frame7 and OptionButton3. What I would like is when a user clicks OptionButton3, a command button is created and inserted in Frame7. I need for it to be located and positioned in the frame at 283 Top and 156 left. I need the dimensions of the button to be 18 height and 78 width. Is this possible to do? Thank you Todd Huttenstine |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating Command button Conditionally
oh great idea. I never thought of that.
Thank you Todd Huttenstine -----Original Message----- The easiest would be to put it where you want it manually, then make it not visible in properties. In the click event of the optionbutton, make it visible -- Regards, Tom Ogilvy Todd Huttenstine wrote in message ... Hey guys I have a userform. On this form are various objects. One them is Frame7 and OptionButton3. What I would like is when a user clicks OptionButton3, a command button is created and inserted in Frame7. I need for it to be located and positioned in the frame at 283 Top and 156 left. I need the dimensions of the button to be 18 height and 78 width. Is this possible to do? Thank you Todd Huttenstine . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Command Button on a worksheet | Excel Discussion (Misc queries) | |||
| Button or key to conditionally change text foreground color? | New Users to Excel | |||
| Button or key to conditionally change text foreground color? | New Users to Excel | |||
| Button or key to conditionally change text foreground color? | New Users to Excel | |||
| Command Button vs Form Button | Excel Programming | |||
![Todd Huttenstine[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
