Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identify which List Box was used
I use the same code connected to several List Boxes. I need the code to
determine which List Box was used to trigger the code. Not sure how I capture that ListBox name. Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identify which List Box was used
Private Sub ListBox1_Click() Set bx = ActiveSheet.OLEObjects("Listbox1") Call CommonBox(bx) End Sub Private Sub ListBox2_Click() Set bx = ActiveSheet.OLEObjects("Listbox2") Call CommonBox(bx) End Sub Sub CommonBox(bx) 'enter code here End Sub -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=148748 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identify which List Box was used
If you used listboxes from the control toolbox toolbar, then you should know
what one triggered the code. If you used listboxes from the Forms toolbar, then you could use: Dim LB As ListBox Set LB = ActiveSheet.ListBoxes(Application.Caller) MsgBox LB.Name & vbLf & LB.TopLeftCell.Address These are listboxes placed on the worksheet, right? jjb wrote: I use the same code connected to several List Boxes. I need the code to determine which List Box was used to trigger the code. Not sure how I capture that ListBox name. Thanks, -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identify Duplicates in a List | Excel Discussion (Misc queries) | |||
identify list used in a cell | Excel Discussion (Misc queries) | |||
how to identify unique list of 200 random entries from a list of 3 | Excel Worksheet Functions | |||
Identify & List unique values from a list using functions/formulas | Excel Worksheet Functions | |||
Identify last item in a list | Excel Discussion (Misc queries) |