Use a named range in an excel worksheet to propagate a listbox
- by user223139
So I have a number of namedRanges in an excel worksheet. I would like to use these to fill in comboboxes on a user form in the same WorkBook.
I have tried:
cboMember.DataSource = Globals.Sheet1.MemberRange.Value
No error is given but the combo is blank. Does anybody have any ideas?
I'm trying to use VSTO for VS 2008 on an excel 2003 work book.