Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message box warning of missing data
Hi,
When a user inputs data (numbers) into cells in column D, they should include a three digit prefix before the numbers. I would like a message box to pop up if they fail to do this and delete what they have put in the cell thus forcing them to try again. For example 09/123 would be rejected but SUM09/123 would be ok. Thanks in advance. -- Traa Dy Liooar Jock |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message box warning of missing data
Select the sheet tab which you want to work with. Right click the sheet tab
and click on 'View Code'. This will launch VBE. Paste the below code to the right blank portion. Get back to to workbook and try out. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 4 And Target.Count = 1 And Target.Text < "" Then If Not Target.Text Like "[A-Z][A-Z][A-Z]#*" Then Target = "": Target.Select 'Msbgox "Display a message" End If End If End Sub -- Jacob "Jock" wrote: Hi, When a user inputs data (numbers) into cells in column D, they should include a three digit prefix before the numbers. I would like a message box to pop up if they fail to do this and delete what they have put in the cell thus forcing them to try again. For example 09/123 would be rejected but SUM09/123 would be ok. Thanks in advance. -- Traa Dy Liooar Jock |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Data Warning Message - I have No External Data in wrkbk | Excel Discussion (Misc queries) | |||
Warning message on "number of data points" | Charts and Charting in Excel | |||
warning message | Excel Discussion (Misc queries) | |||
run macro after yes to data validation warning message | Excel Programming | |||
Pop up warning message! | Excel Programming |