+ Reply to Thread
Results 1 to 2 of 2

Make a cell required

  1. #1
    Registered User
    Join Date
    07-21-2005
    Posts
    1

    Make a cell required

    I want to make a cell that has a drop down list required. eg.: if cell a5 < 0, the drop down option in cell b5 must be chosen, the cell cannot be blank.

    Any suggestions?

  2. #2
    Forum Contributor
    Join Date
    11-16-2004
    Posts
    282

    Making an entry 'required' for a cell

    You can use event macros in Excel to ensure a cell has an entry...

    This macro will check to see if an entry exists in cell B5 if cell A5 is less than zero EVERY TIME a change is made to the worksheet. If both conditions are true, it alerts the user and then selects cell B5 for the user to make an entry. Copy it to the code page of the worksheet that needs the required entry in cell B5:
    Please Login or Register  to view this content.
    Additionally, this macro will check to see if an entry exists in cell B5 if cell A5 is less than zero whenever the user tries to CLOSE THE WORKBOOK. If both conditions are true, it prevents the workbook from closing, alerts the user and then selects cell B5 for the user to make an entry. Copy it to the code page of the This Workbook object in the file:
    Please Login or Register  to view this content.
    Hope this helps,
    theDude

+ 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