Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limiting raw score entries and possible pop up message alert?
I originally posted this in the middle of a previous post of mine. Wasn't
sure if it would get lost from view given that it was inside an all ready resolved problem. Thus, I am reposting it. Sorry for being repetitive............. I have a spreadsheet and I'd like to do is to limit raw score data entry into certain cells. (J4:J5000-S4:S5000, and Z4:Z5000-AI4:AI5000) that should allow only specific raw scores. We developed a rating scale that only allows for scores of 5, 10 or 15 to be entered (per how we set up the rating evaluation sheet). Unfortunately, some of our secretarial staff type fast and makes errors. When checking their data entry, I often find scores of 0, 4, 16, etc. If there is a way (possibly using vba I suspect) to only allow scores of 5, 10, or 5 to be entered into columns J, S, Z, and AI this would prevent accidental entry of numbers that shouldn't be input. I had this idea of a pop up message alert advising the data entry person that only scores of 5, 10, and 15 can be input and avoiding all the calculation errors we often get. Any suggestions? Thanks much Dan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limiting raw score entries and possible pop up message alert?
You can do this with Data Validation. No VBA is requred.
In Excel 2003, Select the cells requring the validation and go to Data - Validation Allow List Enter 5,10,15 (or whatever you allow) You can enter an error message as well. -- HTH, Barb Reinhardt "Dan the Man" wrote: I originally posted this in the middle of a previous post of mine. Wasn't sure if it would get lost from view given that it was inside an all ready resolved problem. Thus, I am reposting it. Sorry for being repetitive............. I have a spreadsheet and I'd like to do is to limit raw score data entry into certain cells. (J4:J5000-S4:S5000, and Z4:Z5000-AI4:AI5000) that should allow only specific raw scores. We developed a rating scale that only allows for scores of 5, 10 or 15 to be entered (per how we set up the rating evaluation sheet). Unfortunately, some of our secretarial staff type fast and makes errors. When checking their data entry, I often find scores of 0, 4, 16, etc. If there is a way (possibly using vba I suspect) to only allow scores of 5, 10, or 5 to be entered into columns J, S, Z, and AI this would prevent accidental entry of numbers that shouldn't be input. I had this idea of a pop up message alert advising the data entry person that only scores of 5, 10, and 15 can be input and avoiding all the calculation errors we often get. Any suggestions? Thanks much Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LIMITING DATA VALIDATION ENTRIES | Excel Discussion (Misc queries) | |||
Message alert | Excel Discussion (Misc queries) | |||
Alert Message | Excel Discussion (Misc queries) | |||
Limiting Entries in A List Box | Excel Worksheet Functions | |||
Limiting Validation entries to 2 places after a decimal | Excel Discussion (Misc queries) |