| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
LISTBOX PROPERTIES
Is it possible to have a listbox populate using the activesheet range
a1:b100 Thanks in advance |
|
#2
|
|||
|
|||
|
Try this:
With Worksheets(1) Set lb = .Shapes.AddFormControl(xlListBox, 100, 10, 100, 100) lb.ControlFormat.ListFillRange = "A1:B100" End With "browie" wrote: Is it possible to have a listbox populate using the activesheet range a1:b100 Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Blank spaces in a listbox | Excel Discussion (Misc queries) | |||
| Custom File Properties | Excel Discussion (Misc queries) | |||
| Need help with Listbox | Excel Discussion (Misc queries) | |||
| Help with Excel ActiveX listbox controls | Excel Discussion (Misc queries) | |||
| command button properties | Excel Worksheet Functions | |||
Linear Mode
