| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell with limits
Hi,
When somebody enters a value is a cell I want it not to be higher then (as an example) 10 and only numbers are allowed, no other characters. If entered a messagebox should appear saying something incorrect is entered. What should I do?? Thanks JP |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell with limits
Hello
See Data Validation HTH Cordially Pascal "Jean-Paul De Winter" a écrit dans le message de ... Hi, When somebody enters a value is a cell I want it not to be higher then (as an example) 10 and only numbers are allowed, no other characters. If entered a messagebox should appear saying something incorrect is entered. What should I do?? Thanks JP |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell with limits
Hi JP,
You could use Data validation. See Debra Dalgleish's tutorial at: http://www.contextures.com/xlDataVal01.html -- Regards, Norman "Jean-Paul De Winter" wrote in message ... Hi, When somebody enters a value is a cell I want it not to be higher then (as an example) 10 and only numbers are allowed, no other characters. If entered a messagebox should appear saying something incorrect is entered. What should I do?? Thanks JP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Value Limits in a Cell | Setting up and Configuration of Excel | |||
| How to hide cell limits? Newbie | Excel Discussion (Misc queries) | |||
| PivotCharts (max cell/row limits)? | Charts and Charting in Excel | |||
| cell format limits | Excel Worksheet Functions | |||
| dealing with cell text limits | Excel Discussion (Misc queries) | |||
Linear Mode
