Issue clearing combobox on change

[TonyFurioso]

Currently, my combobox will copy a selection to an active cell and offset to the next cell. My problem is that the selection is not cleared. When i attempted to add combobox = null to the end of the macro, it clears the offset cell that was activated and offsets once more.

Id like to offset to the next cell, clear the combobox selection and not affect the now activated cell i offset to in doing so.

This works but does not clear or refocus the combobox

Please Login or Register  to view this content.

Any help would be appreciated. Thanks!

[AlphaFrog]

Maybe something like this...

Please Login or Register  to view this content.

[xladept]

Ho Tony,

Try:

Please Login or Register  to view this content.

[TonyFurioso]

That worked! Do you have any idea why ComboBox.Value = NULL doesnt work the same way?

[AlphaFrog]

NULL is not a key word or constant in VBA. You would use "" or vbNullString.

Also, if you previously used the ComboBox1_Change procedure instead of the ComboBox1_Click procedure, it would trigger twice and clear the next active cell because the combobox would change twice. The second change is when it's cleared.