Using Find and Replace All Boxes in VBA

Dear All,

Trust you're all doing well.

I am taking an Excel file and I am restructuring all the VBA codes as well renaming all boxes for easy management.

At the moment, all boxes are standard name such as “TextBox#”; “CheckBox#” and so on. I have renamed them and need to replace now the new names for all codes.

Best way I know is to use the “Find and Replace” but I encounter issues when boxes exceeds 2 decimal numbers. For example, if I want to replace all “TextBox1” to “TxBxName” and choose replace all, it will replace e.g. “TextBox13” to “TxBxName3”. What I want is only to replace the “TextBox1” and not the “TextBox11, TextBox12” as this ones have another id/name.

Is there a workaround to avoid this? The only one I know is to do it one by one and ignore the decimal ones but this will take ages as there are loads of Boxes and codes.

Please do let me know if you require further clarification.

Many thanks in advance for your help.

Best regards,
Filipe

LOL, actually it makes all sense alright!

Thanks a million xlnitwit, will do it.

Will keep this thread open to see if there is another way to do it but, in all fairness, will be hard to beat yours

Appreciate your assistance.