ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   listbox and variables (https://www.excelbanter.com/excel-programming/302309-re-listbox-variables.html)

Anson[_2_]

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



All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com