Change userform listbox border with change event

[EuclideanKraken]

I am trying to create a userform that has all the fields highlighted until a user makes a selection. I have been trying to do this by changing the border color from red to gray with a change event, but it isn't working.

I can change the listbox formatting with a UserForm_Initialize

Please Login or Register  to view this content.

This works. But when I use a listbox click or change event, it does nothing.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Can anyone point out what I am doing wrong? Why can I change the format of the listbox on initialize, but not on a change or click event?

[Cerbera]

I don't know if there is any limitation outside of the "initialise" event, I'm sure someone else will know the answer on that(?).

As a (far from ideal) alternative could you store the variables and reinitialise the form with the updated formatting?

[EuclideanKraken]

Thanks for your reply. I had that idea myself, but decided it wasn't worth the hassle. I ended up just giving up going another route.