+ Reply to Thread
Results 1 to 8 of 8

Restricting the number of cells users can input data to

  1. #1
    Registered User
    Join Date
    08-17-2004
    Posts
    10

    Restricting the number of cells users can input data to

    I am using Excel 2003 on Windows XP.

    I have a spreadsheet which has a number of columns (each representing a piece of equipment), which I am using to track downtime for the equipment.

    When a piece of equipment goes down, the user is to enter an "X" in that column. Previously users could select more than one piece of equipment. For various reasons, I now want to restrict the user so that they can only put an "X" in for one piece of equipment per row.

    Is there any way to do this?
    -----------
    Em

    There are 10 types of people in this world. Those that can read binary and those that can't.

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by LittleEm
    I am using Excel 2003 on Windows XP.

    I have a spreadsheet which has a number of columns (each representing a piece of equipment), which I am using to track downtime for the equipment.

    When a piece of equipment goes down, the user is to enter an "X" in that column. Previously users could select more than one piece of equipment. For various reasons, I now want to restrict the user so that they can only put an "X" in for one piece of equipment per row.

    Is there any way to do this?
    A Workksheet change event could trap the second (and subsequent) x, are you familiar with VB code?


    ---
    There are 3 kinds of people in the world, those who can count and those who can't.
    Si fractum non sit, noli id reficere.

  3. #3
    Registered User
    Join Date
    08-17-2004
    Posts
    10
    reasonably... no formal training though, just self taught!

  4. #4
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by LittleEm
    reasonably... no formal training though, just self taught!
    Hi,

    what range of cells for the 'X' ?

    ---

  5. #5
    Registered User
    Join Date
    08-17-2004
    Posts
    10
    Here's a copy of the sheet...

    This is only a cut & paste from a bigger file, so I've removed all the formulae because they link to other sheets. But essentially anything green is for user input, grey is background or formulae. The "X" will be going in columns B to M.
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by LittleEm
    Here's a copy of the sheet...

    This is only a cut & paste from a bigger file, so I've removed all the formulae because they link to other sheets. But essentially anything green is for user input, grey is background or formulae. The "X" will be going in columns B to M.
    for B to M, something like
    Please Login or Register  to view this content.
    and you need to decide what to do when the second X appears.

    hth
    ---
    amended - remove Target = X test
    Last edited by Bryan Hessey; 11-29-2006 at 10:54 PM.

  7. #7
    Registered User
    Join Date
    08-17-2004
    Posts
    10
    Thanks...

    It didn't quite work the first time, needed to add in a line so that:

    iRow = Target.Row (in the end I just replaced iRow with Target.Row)

    but other than that, it does exactly what I want (have set it up so that if there are two X's, after the message box, it clears the Target cell)

    thanks for your help

  8. #8
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by LittleEm
    Thanks...

    It didn't quite work the first time, needed to add in a line so that:

    iRow = Target.Row (in the end I just replaced iRow with Target.Row)

    but other than that, it does exactly what I want (have set it up so that if there are two X's, after the message box, it clears the Target cell)

    thanks for your help
    OK - good to see, I wasn't sure what you wanted, 'clear' sounds good.

    Thanks for the response.
    ---

+ 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