Help! Named Range in VBA

[megnin]

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!!

 

[Juan Pablo González]

Well, it would be easier to use the

ComboBox1.Value

but, you can use

Range("MyRange")(ComboBox1.ListIndex + 1)

or

Range("MyRange").Item(ComboBox1.ListIndex + 1).Value

that's a little bit "harder"

 

[megnin]

Thank you. Great suggestions! I'm new to this so eager to learn the basics.

Thanks again!!

 

[megnin]

Now how do I tell what number a DropDown Box is?

I've copy & pasted them everywhere and they all say they are "DropDown14" when I select "Assign Macro". "Properties" only show whether it will print or not.

Thanks!