Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check a column for correct type of data
I have a worksheet that has to have dates manually inputted where I then have
my own macro do some other stuff. Is there a way to check the A column for date data and have a box popup telling them if they havent while also stopping the macro? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check a column for correct type of data
one way
Sub checkdate() For Each c In Selection On Error Resume Next If Not IsDate(c + 1) Then MsgBox c.Address '"not a date" Next End Sub -- Don Guillett SalesAid Software "TWilson" wrote in message ... I have a worksheet that has to have dates manually inputted where I then have my own macro do some other stuff. Is there a way to check the A column for date data and have a box popup telling them if they havent while also stopping the macro? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dup check 2 columns - need it to delete correct one | Excel Worksheet Functions | |||
userform-check data type | Excel Programming | |||
Excel: How do I type a letter in a column and make a check mark a. | Excel Worksheet Functions | |||
create macro to move label type data to column data | Excel Programming | |||
How to check a Variant for its data type | Excel Programming |