Listbox - editable cell background color

Davide_Pagano · September 1, 2016, 2:33pm

Hi,

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.

Thanks.

Merv_Pate · September 1, 2016, 4:05pm

In the CellGotFocus event, add:

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

Urs_Geiser · September 1, 2016, 4:08pm

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

Merv_Pate · September 1, 2016, 4:11pm

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

Urs_Geiser · September 1, 2016, 4:21pm

Probably not. I didn’t think about that.