+ Reply to Thread
Results 1 to 5 of 5

Solution to populate cell with "X" by selecting "R"

  1. #1
    Registered User
    Join Date
    02-20-2008
    Posts
    50

    Solution to populate cell with "X" by selecting "R"

    Members Hi,

    I'ld like to prepare a quality sheet - to be updated by my team members - daily.

    The sheet will have the name of the each member along with the key fields - 7, they will be checking.

    Suggest a solution wherin 'X' should be populated in the cell where in they find any issue - 'X' should populate by pressing any specific key on hte key board (may be R) .

    Appreciate your help to determine how to get the "X" populated by pressing R.

    Thks,
    Nirola

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Solution to populate cell with "X" by selecting "R"

    Why can't they just press X ?

    Pete

  3. #3
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Solution to populate cell with "X" by selecting "R"

    You could do this with a macro and assign a shortcut key of ctrl + r

    Please Login or Register  to view this content.
    HTH
    Regards, Jeff

  4. #4
    Registered User
    Join Date
    02-20-2008
    Posts
    50

    Re: Solution to populate cell with "X" by selecting "R"

    Ok, but I want that as and when they get an error they should press any key on the keyboard and 'X' should appear in the cell...

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Solution to populate cell with "X" by selecting "R"

    use datavalidation, then you always get the right input.

    excel 2007:

    Data => Datavalidation
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ Reply to Thread

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