UserForm Listbox doesn't update
 

Hi,

I have linked listboxes in a UserForm. Actually, I've written code to
link them, such that if somebody chooses option A in ListBox 1, then
ListBoxes 2 and 3 update with new choices.

I've gotten the ListBoxes to successfully update with the new choices.
However sometimes the choices show up as blank. The user can actually
click on the blank choices--and Excel picks up the choice. But you
cannot actually see the choice. Sometimes the choice shows up again
after you scroll up and down in the listbox.

Anybody know what's up with this?

Thanks.


--
befar
------------------------------------------------------------------------
befar's Profile: http://www.excelforum.com/member.php...o&userid=34682
View this thread: http://www.excelforum.com/showthread...hreadid=544480

UserForm Listbox doesn't update
 

You could try adding Me.Repaint at the appropriate point(s) in your code.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"befar"
wrote in message
Hi,
I have linked listboxes in a UserForm. Actually, I've written code to
link them, such that if somebody chooses option A in ListBox 1, then
ListBoxes 2 and 3 update with new choices.

I've gotten the ListBoxes to successfully update with the new choices.
However sometimes the choices show up as blank. The user can actually
click on the blank choices--and Excel picks up the choice. But you
cannot actually see the choice. Sometimes the choice shows up again
after you scroll up and down in the listbox.
Anybody know what's up with this?
Thanks.
--
befar