VBA change cell value based on it's value

[ceytl]

Hi,

I am trying to write a VBA script to do the following:

In cell F1 there can be five different values.

I want the cell value to change to the following depending on the value in F1:

"1 New York" change to "21"
"2 LA" change to "22"
"3 Portland" change to "23"
"4 Chicago" change to "24"
"5 Miami" change to "25"

Any help would be appreciated!

 

[Joe4]

Thanks for this great feedback Joe, my VBA is a bit rusty indeed since I switched to Python

No worries!