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:
Populating cells (after duplicating the last row of dataPlease 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.Please Login or Register to view this content.
Any help will be appreciated.
Robert
Bookmarks