Assign a variable from a Listbox selection.
 

I have set a variable "AuditorName" as public and as a string.

I have a ListBox which has numerous entries and can scroll to selec
whichever i want.

The problem is that i can't seem to get the selection on the ListBox t
assign as the value to "AuditorName"

Next to the ListBox i have a commandbutton which i was going to use i
a way that once "Clicked" would confirm the selection on the ListBo
and thus that value would then be the value of "AuditorName".

Hope that makes sense. Any ideas appreciated as i just cannot seem t
get the little "Bugger" to work.

TI

--
Message posted from http://www.ExcelForum.com