Referenceing a combo box on a sheet

I have the code below and now have a combo box on C2 cell.  How do I change the code below to reference that combox now.  

              sp.Periods = Sheets("Summary").Range("C2")
leezacAsked:
Who is Participating?
 
nutschCommented:
If the combobox linked range is C2, you can still use the same code.
0
 
leezacAuthor Commented:
I am not sure how to do that.
0
 
leezacAuthor Commented:
I just saw in Properties where it asks for Linked Cell.
0
 
nutschCommented:
Glad that helped.

Thomas
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.