Simple VBA - Find and replace?

[acnation]

This seems like a fairly basic task, but I'm fairly new to VBA and I'm still learning the appropriate syntax. In a simplified way it goes like this.
I want to create a macro that takes the stores three different variables that the user types into an input value box.
V1, V2, V3
I need the macro to do the following.

• 1. Ask user to variable V1, V2, V3.
• 2. Find V2, and replace it with V3.
• 3. Then (order is important) Find V1 and replace it with V2.

Example:

• 1. Enter: V1 = May, V2 = June, V3 = July
• 2. Find June and replace it with July
• 3. Find May and replace it with June

This seems fairly simple but I'm not sure how to go about with it. Any help would be greatly appreciated. Thanks so much!

 

[dermie_72]

If you record a macro of you doing a find replace, Control + H, stop recording after completing both functions.

Have particular cells that contains V1 V2 and V3.
Let's say they are in Cell V1, V2 and V3.
Have Range("V1").Value = V1
Range("V2").Value = V2
Range("V3").Value = V3

Then when you locate the find/replace code, you replace the "looked for" with V2 and "Replace with" with V3, then "looked for" with V1, and "Replaced with" with V2.