Data Entry Only

[laihung8]

Hi Team,

I want to set up the cell only allow to enter date and the month in text. What vba code I should use? Help please!

July
7/1/2011

 

[Macklin]

Can you just set the number format of the cell to month?

or maybe this kinda thing:

DCDATE = Me.TextDC.Value
DCDATE = DateSerial(Year(DCDATE), Month(DCDATE), day(DCDATE))

I am making sure the date is formatted the way I want.

Or I suppose you could just do an IF THEN statement to see if the entry is a valid month with a msgbox error statement.

I am new and these are my guesses, maybe it will get ya going until you get more help.