Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify excel userform controls through vbproject?
(Excel vX for Macintosh)
Does anyone know if it is possible to set properties of controls on an excel userform using the vbproject. I know I can set the textbox heights etc... at run-time, but as there are many changes I want to make to many controls I wonder if there is any quick way of doing this in the VB editor (without using the normal interface, which would be quite slow). I can get the userform as a vbcomponent using thisworkbook.vbproject.vbcomponents("formname") but I can't seem to do what I want with this. Is there any way of returning the userform object via the vbproject? Thanks David --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting a handle on Userform controls | Excel Programming | |||
Trouble w/ ActiveX Controls (no userform) Excel 2002. | Excel Programming | |||
Hyperlinks from UserForm Controls | Excel Programming | |||
Add controls to UserForm | Excel Programming | |||
load userform from other VBProject (Excel 2000) | Excel Programming |