UserForm Listbox doesn't update

  • Thread starter Thread starter befar
  • Start date Start date
B

befar

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.
 
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.
 
Back
Top