ExcelBanter - LISTBOX PROPERTIES

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - LISTBOX PROPERTIES (https://www.excelbanter.com/excel-discussion-misc-queries/41592-listbox-properties.html)

browie

LISTBOX PROPERTIES

Is it possible to have a listbox populate using the activesheet range
a1:b100

Thanks in advance

StinkeyPete

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

All times are GMT +1. The time now is 11:17 PM.