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