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?
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?
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:
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,Please Login or Register to view this content.
theDude
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks