ExcelBanter - List Box

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - List Box (https://www.excelbanter.com/excel-programming/373643-list-box.html)

Topher

List Box

I am an enthusiastic amateur just starting our at this VBA business. I
appreciate I may appear €˜slow but this issue has be vexed. How do I
populate a listbox or combobox in a userform from a named range on a
€œReference€ worksheet?

Tom Ogilvy

List Box

assume the named range is MyRange

in the rowsource property of the listbox enter

MyRange

--
Regards,
Tom Ogilvy

"Topher" wrote:

I am an enthusiastic amateur just starting our at this VBA business. I
appreciate I may appear €˜slow but this issue has be vexed. How do I
populate a listbox or combobox in a userform from a named range on a
€œReference€ worksheet?

Topher

List Box

Thanks Tom... Easy when you know how!

"Tom Ogilvy" wrote:

assume the named range is MyRange

in the rowsource property of the listbox enter

MyRange

--
Regards,
Tom Ogilvy

"Topher" wrote:

I am an enthusiastic amateur just starting our at this VBA business. I
appreciate I may appear €˜slow but this issue has be vexed. How do I
populate a listbox or combobox in a userform from a named range on a
€œReference€ worksheet?

All times are GMT +1. The time now is 10:02 PM.