Results 1 to 3 of 3

Offset Inputbox function - change cell colour

Threaded View

  1. #1
    Registered User
    Join Date
    06-01-2004
    Posts
    36

    Offset Inputbox function - change cell colour

    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
    Last edited by pike; 03-25-2011 at 08:49 PM. Reason: In proper Title

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1