Solved

Referenceing a combo box on a sheet

Posted on 2014-03-26
4
162 Views
Last Modified: 2014-03-26
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
Comment
Question by:leezac
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 39

Accepted Solution

by:
nutsch earned 290 total points
ID: 39956966
If the combobox linked range is C2, you can still use the same code.
0
 

Author Comment

by:leezac
ID: 39957002
I am not sure how to do that.
0
 

Author Comment

by:leezac
ID: 39957007
I just saw in Properties where it asks for Linked Cell.
0
 
LVL 39

Expert Comment

by:nutsch
ID: 39957044
Glad that helped.

Thomas
0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question