Listbox.value is null

**Hammer_757** · 12-30-2012, 10:59 PM

On a userform I have two lisboxes that are populated from named ranges. The listboxes are populated correctly when the form is initiated and I can scroll through the choices in both listboxes but their respective cells do not get filled and .value for both is “NULL”.

Listbox setup:

Please Login or Register  to view this content.

Populating cells (after duplicating the last row of data

Please Login or Register  to view this content.

My guess is that I cannot use the value property in this way but reading through the help and on line I cannot find a simple way to extract a single value from a listbox.

Any help will be appreciated.
Robert

**Norie** · 12-31-2012, 12:11 AM

Robert

Are the listboxes multiselect?

**Hammer_757** · 12-31-2012, 09:13 AM

Originally Posted by Norie

Robert

Are the listboxes multiselect?

Norie,
No, they are single.
Attaching the file. the Form is initiated by the "Add Employee" button at the bottom of the data range on the first sheet.
Thanks for helping

**JosephP** · 12-31-2012, 09:28 AM

that works for me as long as you actually select (ie highlight) an item in each listbox-which I suspect you aren't

**Hammer_757** · 12-31-2012, 09:52 AM

Your right Joseph, I wasn't actually highlighting the choice. Which means, my users probably will make the same mistake. I need to rethink this approach.
Thanks for setting me strait!
Robert

**Norie** · 12-31-2012, 09:58 AM

Robert

Wouldn't it make more sense to use comboboxes if you are only going to display one value?

**Hammer_757** · 12-31-2012, 11:41 AM

Yes Norie, I'm shifting them of to comboboxes

Listbox.value is null

LinkBack

Thread Tools

Rate This Thread

Display

Listbox.value is null

Re: Listbox.value is null

Re: Listbox.value is null

Re: Listbox.value is null

Re: Listbox.value is null

Re: Listbox.value is null

Re: Listbox.value is null

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions