Assign a variable from a Listbox selection.
 

Jako

Have you set the variable "AuditorName" as public
in a *general module*?

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Jako " skrev i en meddelelse
...
I have set a variable "AuditorName" as public and as a string.

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

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

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

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

TIA


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