View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anson[_2_] Anson[_2_] is offline
external usenet poster
 
Posts: 28
Default listbox and variables

Try

Private Sub SSDC_Change()
Dim temp as string
temp = SSDAC.value
End sub

"Bill" wrote:

How do you load the selection from a listbox into a variable?

Private Sub userform_initialize()
Dim temp As String

SSDAC.List() = Array("jw0983", "jv6684", "mm2900", "el1765")
temp$ = SSDAC.List()

End Sub