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
Microsoft Excel
Last Comment
Bright01
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.