Mask in Userform

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• May 19, 2003

• #2

It may be possible to write some code to validate a TextBox for a date - what format?

On the other hand it may be easier to use the CalendarControl or ComboBoxes for day/month/year.

 

Upvote 0

M

MKMM

New Member

Joined

May 19, 2003

Messages

39

• May 19, 2003

• #3

The format is dd/mm/yy. How can I write a code to validate a TextBox?

What is a CalendarControl and how can I use it?

 

Upvote 0

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• May 19, 2003

• #4

While in a UserForm in the VBE right click the Control Toolbox and choose Additional Controls. You should see Calendar Control in the list - check it and click OK.

 

Upvote 0