Listbox - editable cell background color


I have listbox where I customized the text and background colors. However a cell becomes editable the background color is white again…how to customize that? I could not find a way to do so.


In the CellGotFocus event, add:

Me.ActiveCell.BackColor = &cD0D0D0 ’ or whatever color you want

The CellClick event also works to apply the settings to Me.ActiveCell.

I am not sure, but does the CellClick event work when you start the edit with a Keypress?

Probably not. I didn’t think about that.