Hey Guys
Done a search but not found exactly what I need.
Basically what I am trying to achieve is, having cell A1 have the word "red" or "green" inputted, and basically a vba code such as
If cell A1 had the word RED, I would want the following:
Private sub colourchange()
'run macro name based off cell A1
run red
end sub
But say cell A1 had the word GREEN, I would want the following to happen:
Private sub colourchange()
'run macro name based off cell A1
run green
end sub
Hope you understand what I am trying to achieve.
Many thanks in advance,
Ash
Bookmarks