Combo Box - Selected

[AlexanderBB]

Is it possible after a new item is selected to NOT have it highlit ?

 

[Logit]

.
UNTESTED HERE

[COLOR=#242729][FONT=Arial]Just set it to <code style="margin: 0px; padding: 1px 5px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-size: 13px; vertical-align: baseline; box-sizing: inherit; background-color: rgb(239, 240, 241); white-space: pre-wrap;">0</code> after you have selected the default item and you should be good to go:

[/FONT][/COLOR]
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">[COLOR=#303336][FONT=inherit]ComboBox1[/FONT][/COLOR][COLOR=#303336][FONT=inherit].[/FONT][/COLOR][COLOR=#303336][FONT=inherit]SelectionLength [/FONT][/COLOR][COLOR=#303336][FONT=inherit]=[/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]0
[/FONT][/COLOR]</code>

https://stackoverflow.com/questions...ht-of-combobox-when-an-item-is-selected-in-vb

 

[AlexanderBB]

Doesn't seem to do anything.. (that's SelLength, couldn't find SelectionLength).
Tried the Change and AfterUpdate events.

 

[Logit]

.
Having more time this morning ... this is tested and works here :

Option Explicit


Private Sub ComboBox1_Change()
    Me.Range("A1").Select
End Sub

Paste the above in the Sheet level module where the ComboBox resides. I used an ActiveX ComboBox pasted onto the sheet.

Perhaps you may want to change the focus to another part of the sheet instead of cell A1 ?