Bright01
asked on
Changing Text in a Range Named and Macro Assigned "Box"
EE Pros,
I have a graphic where I'm trying to change the text in the textbox in cell (B2) from "Select an Outcome" to "Select an Area of Optimization". The problem I have run across is that the text is used in a macro and is also a range name and I cannot figure out how to change the text (I've tried to change the range name and tried to change the text in the Macro).
I'm looking for "how" to do this so I can learn.
Thank you in advance.
B.
Changing-Text-in-a-Range.xlsm
I have a graphic where I'm trying to change the text in the textbox in cell (B2) from "Select an Outcome" to "Select an Area of Optimization". The problem I have run across is that the text is used in a macro and is also a range name and I cannot figure out how to change the text (I've tried to change the range name and tried to change the text in the Macro).
I'm looking for "how" to do this so I can learn.
Thank you in advance.
B.
Changing-Text-in-a-Range.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I cannot understand what you are looking for!
ASKER
Raganzo,
Thank you! Works now. Appreciate you letting me know exactly what you did. I had tried that earlier but had missed the second reference point.
I have another question outstanding; if you get a chance, take a look.
Thanks again,
B.
Thank you! Works now. Appreciate you letting me know exactly what you did. I had tried that earlier but had missed the second reference point.
I have another question outstanding; if you get a chance, take a look.
Thanks again,
B.