Question on combobox

[Peter-Jan De Smedt]

Dear all

Could somebody help me with below? I have a combobox and when I select one of the values from the drop down list it remains highlighted in blue. It only becomes not highlighted again when I click any other cell. For the rest it works fine. I played around with the properties but no luck... Anyone an idea? Your help would be much appreciated.

KR

John

 

[Hui]

John


That's what Comboboxes are meant to do


Once you select a value, it is selected


If you want to select a value that isn't part of your list add a "(None)" etc to the list


eg:

(None)

North

South

East

West


Obviously you now have to allow for that selection in your code/formulas

 

[Peter-Jan De Smedt]

Thanks for your help and reply Hui!

I'll have to live with that then it seems ;-)