[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 180
  • Last Modified:

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")
0
leezac
Asked:
leezac
  • 2
  • 2
1 Solution
 
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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now