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”.
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.
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
Last edited by Hammer_757; 12-31-2012 at 09:16 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
LinkBack URL
About LinkBacks
Register To Reply
Originally Posted by Norie
Bookmarks