| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating controls using code
Hi, I have created a user form in excel. I want to make checkbox dynamically when a user presses a comand button. Can anyone please help me out. Regards, Ashish -- ashishprem ------------------------------------------------------------------------ ashishprem's Profile: http://www.excelforum.com/member.php...o&userid=31485 View this thread: http://www.excelforum.com/showthread...hreadid=517648 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
creating controls using code
Hi,
I have created a user form in excel. I want to make checkbox dynamically when a user presses a comand button. Can anyone please help me out. Regards, Ashish Your best bet is not to create the control dynamically, but for it to be there already but invisible and make it visible when the button is pressed. Add the checkbox to the form and set its Visible property to False. Then add this line to the button's Click event: Checkbox1.Visible = True Obviously, replace "Checkbox1" with the name of your checkbox. HTH, Stewart |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating controls to autofill a form | Excel Discussion (Misc queries) | |||
| Creating ATL controls for Excel.. | Excel Programming | |||
| Creating Userform Controls on Frame | Excel Programming | |||
| creating dynamic controls | Excel Programming | |||
| creating controls at runtime | Excel Programming | |||
![ashishprem[_11_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
