| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing control properties/code through code
Is there a way to change the properties of the objects/controls through code
(eg : changing the height, top, left, caption of already existing frame on userform1) and also can we create ...like Command buttons to the form through code and add the code to that button. Suggestions will be highly appreciated. -- Ajit |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing control properties/code through code
Hi Ajit
Creating a UserForm Programmatically http://www.j-walk.com/ss/excel/tips/tip76.htm See also How to use Visual Basic for Applications (VBA) to change UserForms in Excel 2003, Excel 2002, and Excel 2000 http://support.microsoft.com/default...b;EN-US;829070 -- Regards Ron de Bruin http://www.rondebruin.nl "Ajit" wrote in message ... Is there a way to change the properties of the objects/controls through code (eg : changing the height, top, left, caption of already existing frame on userform1) and also can we create ...like Command buttons to the form through code and add the code to that button. Suggestions will be highly appreciated. -- Ajit |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing control properties/code through code
I figured out how to create new userform and create controls and changing the
properties of the same... Thanks to this wonderful community.... Next thing i am looking for is to write some code for checkbox at the time of creation (eg: if checkbox is clicked then bold it). "Ajit" wrote: Is there a way to change the properties of the objects/controls through code (eg : changing the height, top, left, caption of already existing frame on userform1) and also can we create ...like Command buttons to the form through code and add the code to that button. Suggestions will be highly appreciated. -- Ajit |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing control properties/code through code
Thanks Ron,
I will work on it and i am sure it is everything i required. I appreciate your help! "Ron de Bruin" wrote: Hi Ajit Creating a UserForm Programmatically http://www.j-walk.com/ss/excel/tips/tip76.htm See also How to use Visual Basic for Applications (VBA) to change UserForms in Excel 2003, Excel 2002, and Excel 2000 http://support.microsoft.com/default...b;EN-US;829070 -- Regards Ron de Bruin http://www.rondebruin.nl "Ajit" wrote in message ... Is there a way to change the properties of the objects/controls through code (eg : changing the height, top, left, caption of already existing frame on userform1) and also can we create ...like Command buttons to the form through code and add the code to that button. Suggestions will be highly appreciated. -- Ajit |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code cancels protection properties | Excel Programming | |||
| Locking VBA code via Project properties but cannot save the workbook over itself | Excel Programming | |||
| how view a WS code/properties | Excel Programming | |||
| File Properties Code | Excel Programming | |||
| Setting Font properties in Code clears Undo list | Excel Programming | |||
Linear Mode
