Software
We are conslidating a worksheet for the annual achievement in our department. We are looking for a way to make sure that all department members fill all the cells within that active part of the worksheet so that they should not leave any blank.
Is there any way to make Excel look after this job.
by brian
It is easy to do this for a particular cell by using the isnumber or isblank formula. I don't know how to do this for a range or group of cells. It isn't as easy as it would seem.
An option would be to use conditional formating (in the formatmenu) to show a red pattern on cells that contain a particular value that you could set as the default. You could pick a number that would be unlikely to be used and then copy that format to all the cells that need data input into them. The boxes will stay red until data is entered.
Another way to make sure data gets entered into every cell is to create a data entry Worksheet, in this case one for each member or the dept. This way you can simply scan the data entry sheet and quickly see if there are any blanks. It is easy to then create a formula in the destination cell that enters whatever is on the data entry page.
You may already know all of this but if not hope it helps!
by nouhhassan
by dklippert
It is easy to achieve in Access. You can set up required fields. In Excel, at the worksheet level, you have to deal with ?Events?.
Look at www.cpearson.com/excel/events.htm and www.cpearson.com/excel/AppEvent.htm .
You could also create a form andthen attach a macro to the Enter button that would check field entries.
Such as:
If TextName.Text = ?? Then
MsgBox ?You must enter a name.?
Exit Sub
End If
You might also want to look at Excel 2000 Power Programming with VBA by John Walkenbach ISBN 0-7645-3263-4. Chapter 18 cover Events.
I wish it were easier to do what would appear to be a common problem.
by nouhhassan
by nouhhassan
This discussion is closed to new replies.
Sort by Trending