Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pass highlighted list variable to caption
When the user click on an item in a list, I want the name of the item passed
to a caption box. What do I pass to the caption. The following below does not work Private Sub ListBox1_Click() Me.Label2.Caption = List.Selected End Sub Thanks EM |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pass highlighted list variable to caption
Here it is
Private Sub ListBox1_Click() Me.Label2.Caption = ListBox1.Value End Sub "ExcelMonkey" wrote: When the user click on an item in a list, I want the name of the item passed to a caption box. What do I pass to the caption. The following below does not work Private Sub ListBox1_Click() Me.Label2.Caption = List.Selected End Sub Thanks EM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Defining UserForm Caption from a Variable | Excel Worksheet Functions | |||
Pass a Variable List Of Values To Subroutine or Function | Excel Programming | |||
Pass Variable Question | Excel Programming | |||
Userform - Label Caption - How to update from a variable | Excel Programming | |||
How to pass variable value between macros | Excel Programming |