Listbox Update on user form

**Irish_Griffin** · 10-02-2009, 01:48 PM

HAPPY FRIDAY WEEKEND WARRIORS!!!

So, I have searched high and low but I can't find any good examples of a listbox in a user form..... Any code , link or examples would be greatly appreciated!!!!

Here is what I'm trying to do:

On load of userform:
- vba scans sheet and determines what rows are not hidden
- vba updates listbox to show non hidden rows with multiple columns

Thanks,
Griff

**Irish_Griffin** · 10-02-2009, 03:12 PM

double post........

**Irish_Griffin** · 10-02-2009, 03:47 PM

Please, Someone explain how I can assign values into a list box.

this isn't working

Please Login or Register  to view this content.

**Irish_Griffin** · 10-02-2009, 04:04 PM

Running out of coffeeeeee..... Friday night, want to go party.... not ... much...time..... must resist sneeking out of office =-P

**royUK** · 10-03-2009, 04:06 AM

Youv'e not actually said what you want, are you sking for code to load the ListBox or update it as your Thread Title implies?

Attach a sample workbook so that we can see what your data layout is

**Andy Pope** · 10-03-2009, 06:27 AM

Your second command simply overwrites the first columns contents.
Assuming your listbox has the columncount set to 2 or more

Please Login or Register  to view this content.

**Irish_Griffin** · 10-15-2009, 02:41 PM

For search purposes:

This site has a great easy to understand multi column listbox example.

PEACE
Griff

Listbox Update on user form

LinkBack

Thread Tools

Rate This Thread

Display

Listbox Update on user form

re: Listbox Update on user form

re: Listbox Update on user form

re: Listbox Update on user form

Re: Listbox Update on user form

Re: Listbox Update on user form

Re: Listbox Update on user form

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions