ComboBox font color
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 |
ComboBox font color
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) "Smurfette18" wrote in message oups.com... 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 |
ComboBox font color
Thanks Chip! Worked perfectly.
On Oct 26, 8:29 pm, "Chip Pearson" wrote: 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) "Smurfette18" wrote in message oups.com... 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- Hide quoted text - - Show quoted text - |
All times are GMT +1. The time now is 05:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com