Hey folks,
I believe I got an easy one here. I am getting the user to enter two values via Inputbox function. First value is U, D, L, or R and second input is 1, 2, 3 or 4. Based on user input, I want to color the corresponding cell from D8 based on input. For example, if they hit U for Up and 3, I want to color cell D5 with yellow. If they hit R for Right and 4, I want to color cell A8 with Red. I am running this in VBA and I am thinking offset but any suggestions would be great.
Thank you
Bookmarks