MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Problem with Listboxes

  Asked By: Waldemar    Date: Sep 03    Category: MS Office    Views: 1535

Again a new problem for me with dynamically created listboxes. I am creating Listboxes dynamically ie I am creating listboxes based upon the number given in a particular cell. I am updating the items in the listboxes based upon the items in other sheets of the same workbook.
I couldnot select the items in the listboxes sometimes. But the problem is not consistent. When I shift between the sheets and come back to the sheet where there are listboxes, I could select the items.



3 Answers Found

Answer #1    Answered By: Edfu Massri     Answered On: Sep 03

Well, this isn't a solution.....more like a work-around. Have you tried adding code to the end of the list-box building code to switch sheets?

In other words, have it create the list boxes, switch to sheet  B, then switch back  to the sheet with the list-boxes? That way it would automatically do what's needed to fix it without the user ever knowing it needed fixing.

Hopefully someone knows why it's doing it (I'd love to know why myself), but if it's as urgent as you say it is, maybe the work-around will work for you.

Answer #2    Answered By: Samuel Costa     Answered On: Sep 03

That is not I have done, I manually switched between the sheets. And We should not do switching back  and forth between the sheets. I want the solution more than the work around. It got something to do with the focus of the listboxes. I hope you got me.

Answer #3    Answered By: Dirck Jansen     Answered On: Sep 03

How are you updating  them? If you're using code, please include it in your next posting - just cut and paste it into the message body.

Didn't find what you were looking for? Find more on Problem with Listboxes Or get search suggestion and latest updates.