Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I set up some cells in a spreadsheet to be a required fiel.
I am creating a spreadsheet that users will use to select furnishings for
homes in a subdivision. I want to have some of the cells be a 'required field' much like addresses are when one purchases items online. I want the users to be told after all of their selections whether or not they forgot to fill in all applicable cells. Can this be done? |
#2
|
|||
|
|||
I'll assume you have a command button to make calculations after all
entries have been made(?), the command button can call a procedure to check the necessary cells to verify an entry has been made, otherwise, set the focus to that cell. Private Sub CheckForEntry() 'Worksheet Cell "C3" requires an entry If Range("c3") = "" Then MsgBox "Make an Entry in cell C3" Range("C3").Select End If End Sub mickiemaggie wrote: I am creating a spreadsheet that users will use to select furnishings for homes in a subdivision. I want to have some of the cells be a 'required field' much like addresses are when one purchases items online. I want the users to be told after all of their selections whether or not they forgot to fill in all applicable cells. Can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cells() and counting number or rows on spreadsheet | Excel Worksheet Functions | |||
password protected certain cells in spreadsheet | Excel Discussion (Misc queries) | |||
Cells Linked to another spreadsheet | Excel Worksheet Functions | |||
How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions | |||
How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions |