ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Creating Command button Conditionally (https://www.excelbanter.com/excel-programming/288286-creating-command-button-conditionally.html)

Todd Huttenstine[_2_]

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

Tom Ogilvy

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




Todd Huttenstine[_2_]

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



.



All times are GMT +1. The time now is 04:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com