Mahahaava
03-10-2008, 04:22 PM
Hi,
I'm trying to make this happen:
On a UserForm I have ComboBoxes that are populated with values on loading the form. ?The ComboArrows are set to be hidden untill Focus is on the Combo. I would like the Combos to be totally ignorant of mouse-actions untill the Edit Commandbutton is activated.
The problem is that if I lock the Combo's, The "Arrow" will still appear when the combo is selected. If I use Enabled = Flase the values in the boxes are very hard to read.
So the question is twofold:
- is it possible to disable the Arrow with out "graying" out the texts
- is it possible to change the Gray foreground to something more legible?
Thanks in advance,
Petri
I'm trying to make this happen:
On a UserForm I have ComboBoxes that are populated with values on loading the form. ?The ComboArrows are set to be hidden untill Focus is on the Combo. I would like the Combos to be totally ignorant of mouse-actions untill the Edit Commandbutton is activated.
The problem is that if I lock the Combo's, The "Arrow" will still appear when the combo is selected. If I use Enabled = Flase the values in the boxes are very hard to read.
So the question is twofold:
- is it possible to disable the Arrow with out "graying" out the texts
- is it possible to change the Gray foreground to something more legible?
Thanks in advance,
Petri