Replacing Cell Reference in TextBox MS Excel 2007

[mfletcher]

Hi All

I have a formula in a textbox, like ='Flow 0700'!C38 and this causes the text in the textbox to populate with whatever is in cell C38 on worksheet 'Flow 0700' Like a regular formula linking data from another cell.

My worksheet has numerous textboxes with formulas in and I want to update all the formulas to look at a different sheet i.e. Find 'Flow 0700' and replace it with 'Flow 0800'.

Does anyone know any code that can automatically find and replace part of the textbox formula?

Any help appreciated.

Regards
Mark

[RedSon]

Isn't there a find and replace dialog in excel already. Like Ctrl+H or Ctrl+R or something?

[mfletcher]

Hi
There is a find and replace dialog in excel but it doesn't work when trying to replace items in the textbox.