Results 1 to 8 of 8

Populate a cell with a value simply by clicking on it

Threaded View

  1. #1
    Registered User
    Join Date
    07-20-2011
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003
    Posts
    7

    Populate a cell with a value simply by clicking on it

    Hello!

    I am creating an evaluation document. Each area has several traits that I look at. Each trait can be given a 4 (Highly Effective) to 1 (Ineffective) grade. Each grade has its own column, so instead of putting an "x" under the score for each trait or writing a 4, 3, 2, or 1 under each grade, I would like to click on the cell and have that score appear. I have attached a copy of the document with the company-specific information deleted.

    If you open the attachment, let's look at Trait 1 of Area 1 (row 12). I would like to click on G12 and have a "4" appear. If I then click on H12, I would like the cell to show "3" and the "4" in G12 to disappear. I would like this ability to be installed for each trait, and for Observation 1 (columns G-J) and Observation 2 (columns K-N) to not affect one another.

    Any help would be appreciated. Let me know if you need more information.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Populate the range of data in Userform by clicking on cell value which is related
    By haridevadiga in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2013, 02:31 AM
  2. Replies: 1
    Last Post: 02-07-2012, 07:09 AM
  3. Populate dropDown in a custom ribbon on clicking a button
    By johnjacobt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-01-2011, 05:02 AM
  4. how to change cell colour by simply clicking on it
    By lovebunny in forum Excel General
    Replies: 9
    Last Post: 08-10-2006, 02:50 PM
  5. VBA programming: Simply trying to select cell-- or not so simply?
    By whiteliyl_111 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-10-2005, 01:18 PM

Tags for this Thread

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