Prev: Replace Worksheetfunction.ln code
Next: Saving files automatically
From: Jock on 11 Mar 2010 06:54
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
From: Jacob Skaria on 11 Mar 2010 08:56
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
 | 
Pages: 1
Prev: Replace Worksheetfunction.ln code
Next: Saving files automatically