ComboBox font color

  • Thread starter Thread starter Smurfette18
  • Start date Start date
S

Smurfette18

Hello,

I have a userform with a bunch of combo boxes that the user can edit.
I would like to add a few comboboxes for totals that look exactly the
same as the others but do not allow the user to edit them. I tried
disabling these boxes, but that changes the font to grey, while I
would like it to stay black. I also tried using lables instead of
comboboxes for the totals, but I ran into formatting problems.

Any ideas?

Thanks,
-Tim
 
Set the Locked property to True. Be sure to set the ListIndex to >= 0 at run
time to display something because when the control is locked, the user can't
drop down the list.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
Thanks Chip! Worked perfectly.

Set the Locked property to True. Be sure to set the ListIndex to >= 0 at run
time to display something because when the control is locked, the user can't
drop down the list.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consultingwww.cpearson.com
(email on the web site)









- Show quoted text -
Click to expand...
 
Back
Top