View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Dim Userform Control

I'm not sure what you're after, perhaps more detail would be
helpful. But you can declare a variable of a control's type with
code like

Dim MyComboBox As MSForms.ComboBox
Set MyComboBox = UserForm1.ComboBox1


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"donbowyer" wrote in
message
...
Is there an easy bit of code for dimming a UserForm Control
when not in use?
--
donwb