ansaurus

Question

Use a named range in an excel worksheet to propagate a listbox

Answer 1

+1 A:

This is a bit of a guess, but I believe in VBA you can do something like just Range("MyRangeName") to get the named range, so you could try the equivalent of that.

Some ranges in Excel are local to a sheet, some are global to the workbook. If they're local to a sheet then you'll need to prefix with sheet name, e.g. Range("Sheet1!MyRangeName").

Rory 2010-04-28 13:23:48

Thanks RoryGlobals.Sheet1.MemberRange.Value does return the correct values in an array but I cannot get my combobox to bind to it. I think I will have to loop through this array to assign the values to the combobox individually, something like cboMember.additem Globals.Sheet1.MemberRange.Value[i]But I was thinking there must ba an easier way.

Dowlers 2010-04-29 20:37:39

I think you're right that there's an easier way. How about binding a combobox manually then see how it looks when you inspect it with VBA/debugger?

Rory 2010-05-01 21:34:12

Answer 2

+1 A:

cboMember.RowSource = "NamedRange"

You don't set it to an object. Set it to a string. Excel figures out the rest.

ccampj 2010-05-05 05:25:01

ansaurus

tags:

views:

answers:

Use a named range in an excel worksheet to propagate a listbox

related questions