Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading List Box Value
Is is a simple listbox from the control toolbox toolbar?
maybe: Option Explicit Private Sub ListBox1_Click() MsgBox Me.ListBox1.Value End Sub If you have a linked cell, you could just look there, too. Bob Wilcox wrote: Hello, In one module, I have sucessfully created and populated a listbox on a worksheet. My last LOC in that module is to Set objListBox = Nothing. However, in the module, "ListBox_Click" (which does display a MsgBox when clicked), I cannot determine the values of the clicked data. Question, do I use Shapes, Controls or somthing else? What and how do I set the object? B Wilcox -- Dave Peterson |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading List Box Value
I used the command:
Set objListBox = .Shapes.AddFormControl(xlListBox, 400, 10, 100, 400) to create theb list box. -----Original Message----- Is is a simple listbox from the control toolbox toolbar? maybe: Option Explicit Private Sub ListBox1_Click() MsgBox Me.ListBox1.Value End Sub If you have a linked cell, you could just look there, too. Bob Wilcox wrote: Hello, In one module, I have sucessfully created and populated a listbox on a worksheet. My last LOC in that module is to Set objListBox = Nothing. However, in the module, "ListBox_Click" (which does display a MsgBox when clicked), I cannot determine the values of the clicked data. Question, do I use Shapes, Controls or somthing else? What and how do I set the object? B Wilcox -- Dave Peterson . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reading a list of names to update their records | Excel Discussion (Misc queries) | |||
reading from SQL | Excel Discussion (Misc queries) | |||
Reading XML | Excel Discussion (Misc queries) | |||
Reading a large DBF | Excel Discussion (Misc queries) | |||
sub for reading | Excel Programming |