| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pop up vs. data validation
WHOO HOO!
That worked brilliantly! Thanks Jim. "Jim Thomlinson" wrote: The text wrapped when it posted... Try this... Private Sub Worksheet_SelectionChange(ByVal Target As Range) If not intersect(Target, me.range("A1:E1")) is nothing Then MsgBox "Are you sure you want to enter a number here?", _ vbInformation, "???" End If End Sub -- HTH... Jim Thomlinson "carrera" wrote: hmmmm.... it gives me the message compile error; syntax error when I pasted your code. it does that when I click on Any cell on the sheet. Also, how can I make it for a range of cells, let's say A1:E1? do I just replace the $A$1 ? "Jim Thomlinson" wrote: To do what you are asking requires a macro that fires on the selection change event. The following code pops a message box whenever cell a1 is selected. right click the tab and select view code. Paste the following... Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$A$1" Then MsgBox "Are you sure you want to enter a number here?", vbInformation, "???" End If End Sub -- HTH... Jim Thomlinson "carrera" wrote: Because the issue is not what type of number is entered, but why. The reminder message would say something like "Are you sure this is the proper area to enter this number?" "carrera" wrote: I have a reminder set up through data validation whenever certain cells are clicked on. I am seeing that some of the users are ignoring the reminder message, just not noticing it next to the cell. Is there a way to have a pop up warning/reminder come up whenever one of these cells are click up, to which they will have to respond "ok" before entering a number? The number entered could be anywhere from .01 through 39.99 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| Data Validation Update Validation Selection | Excel Worksheet Functions | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Hybrid Mode
