davegugg, In my example i just forgot to show that I had dim'd LB5 As string.
I know that's not my problem.
In regards to setting
LB5 = Me.ListBox5.Value
I've tried this too.
I've got 3 list boxes I'm trying to obtain info from. I've placed a msgbox after each
string variable to visually show me what the value is for each LB. Running the following
code will leave the first LB empty, the second LB will capture the listbox2 value and
the 3rd LB will be empty.
Still seems the only way I can get all 3 listboxes values is to manually select them.
I didn't want to do this but I might have better luck using textboxes.
Still hoping someone might have a solution.
thanks,
BDB
Bookmarks