megnin
Active Member
- Joined
- Feb 27, 2002
- Messages
- 340
How do I refer to a named range in VBA.
I have a Range named "Parts" I use for a ComboBox list.
How can I refer to the selected item by the range name or is it easier to refer to the ComboBox selection in VBA.
I want to past the item selected in the ComboBox into another sheet for a parts list.
Thanks!!
I have a Range named "Parts" I use for a ComboBox list.
How can I refer to the selected item by the range name or is it easier to refer to the ComboBox selection in VBA.
I want to past the item selected in the ComboBox into another sheet for a parts list.
Thanks!!