+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Disable cells and clear contents based on value of the others

  1. 04-15-2011, 04:56 PM #1
    abhinavn
    abhinavn is offline
    Registered User
    Join Date
    11-11-2009
    Location
    detroit
    MS-Off Ver
    Excel 2007
    Posts
    14

    Disable cells and clear contents based on value of the others

    Hello Friends,

    Please help me figure this out and let me know if it is possible
    I have a question in H17, and the answer to this can be any one form I17 to N17. When an "x" is marked in any one cell from I17 to N17 (because there can be only one answer) the other cells are disabled. For ex. If "x" is marked in J17, then I17, K17, L17, M17 and N17 are disabled and no value can be entered into these.
    Similar to H17 to N17, I have another question in H18 to N18 and so on till H23 to N23.

    Thank you for your help

    Regards,
    Ab
    Reply With QuoteRegister To Reply
  2. 04-16-2011, 04:47 PM #2
    mrice
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Disable cells and clear contents based on value of the others

    Try pasting this onto the sheet1 tab in the VBA editor (Alt F11) (assuming your questions are on the first sheet in the workbook.)

    Please Login or Register  to view this content.
    Martin
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1