Friday 10 December 2010

MultiSelect ListBox... how do you read those values??

Title:
MultiSelect ListBox... how do you read those values??Video:


Description:In Excel, you've seen a list box and possibly how to link it to a single cell... what about if it's a Multi Select List Box??? Nothing populates in the linked cell. To do this, use an ActiveX control from the Control Toolbox (not a forms control), and using VBA code, cycle through all the listbox values For i = 0 To ActiveSheet.Shapes.ControlFormat.ListCount - 1 If ListBox1.Selected(i) = True Then ' Do This! (maybe add to an array?) End If Next i

Published:
10/Dec/2010

No comments:

Post a Comment