Populate textboxes from listbox.click

Hi guys

I have been trying to populate a listbox using option buttons then click on the listbox to do a vlookup and populate 4 textboxes. When I open the userform and click on any of the option buttons the listbox populates correctly and so do the textboxes when I click on the listbox item, however when I click on another option button I get an error. First thought was to clear the listbox but this also creates an error.

The option buttons represent 11 different worksheets and the listbox are names taken from those sheets, then use the name to populate the textboxes with info from vlookup.

Please Login or Register  to view this content.

Hope you can understand where Im going with this and any help would be appreciated.

wingnut74

Moderator's note: I have added code tags because it's your first post. Please take the time to review our rules. There aren't many, and they are all important. --6StringJazzer

What error do you get and where do you get it?

PS Can you add code tags?

The problem is caused by using RowSource to populate the listbox.

Either use RowSource = "" to clear the listbox, or don't use RowSource use List.

Please Login or Register  to view this content.

If you are going to use List, make sure you clear RowSource in design view, or in the form's Initialize event.