pschappert
New Member
- Joined
- Nov 30, 2011
- Messages
- 40
Hi,
I'm looking for a way to replace certain words inside a text box based on cell values in a different worksheet. I am not sure if a 'Find and Replace' macro is the best way to do this, but here's an example of what I'm looking for:
(Inside text box on Worksheet 2)
"The quick brown fox jumped over the lazy dog."
(Inside cells A1 on Worksheet 1)
"happy"
My question is, how can I get "happy" to replace "lazy"?
*Note: there are several text boxes that I need to do this in. However, the value in the cell ("happy" in my example) will always be the same. The biggest problem I am facing is the stupid 256-character limit that Excel has placed on formulas inside text boxes.
I appreciate all the help I can get in advance!
Thanks,
Patrick
I'm looking for a way to replace certain words inside a text box based on cell values in a different worksheet. I am not sure if a 'Find and Replace' macro is the best way to do this, but here's an example of what I'm looking for:
(Inside text box on Worksheet 2)
"The quick brown fox jumped over the lazy dog."
(Inside cells A1 on Worksheet 1)
"happy"
My question is, how can I get "happy" to replace "lazy"?
*Note: there are several text boxes that I need to do this in. However, the value in the cell ("happy" in my example) will always be the same. The biggest problem I am facing is the stupid 256-character limit that Excel has placed on formulas inside text boxes.
I appreciate all the help I can get in advance!
Thanks,
Patrick