View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
daithimcc[_3_] daithimcc[_3_] is offline
external usenet poster
 
Posts: 1
Default 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/