Find and replace string in VBA Sub

Fellow Forum Members,
can someone out there please help me out with a VBA script that will do the following:

Open the Code in UserForm1 Private Sub UserForm_Initialize()
Find the string "ABC" and replace it with "123"

Thanks in advance
Detlef

Please Login or Register  to view this content.

Why don't you declare a Global variable and put the sheet name in that?

Please Login or Register  to view this content.

Then, rather than use:

Please Login or Register  to view this content.

use

Please Login or Register  to view this content.

Then you can set it to an initial value of "ABC" wherever you want, and change it to "123" somewhere else.

No need to write code to change code.

Regards, TMS

Hi TMS,
Thanks for your response.
But I'm a Newbie in VBA and don't know what you mean, or how to do it.

I have different products and whenever I choose another Product I need only to replace the "ABC"
with the name of my worksheet.

This what I want to do with my private sub command.

Maybe it is more complicate, but I understand what i'm doing.

If you can give me the code for this, I would be more than happy.

Thanks a lot
Detlef

Maybe it is more complicate, but I understand what i'm doing.

Yes it is and no you don't ... otherwise you wouldn't be asking the question.