VBA: Text Box Property (MASK?) (Easy Question)
 

I want to create a "mask" for my text box, but Im not sure how, I dont
see a clearly labled property for this.

I simply want the text box to show as a Date format:

"__ / __ / ____"

Does anyone know the best way to do this?

Thank you.


--
Mcasteel
------------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698
View this thread: http://www.excelforum.com/showthread...hreadid=275787

VBA: Text Box Property (MASK?) (Easy Question)
 

Excel doesn't support this kind of masking.

But you could format your value nicely before you put it in the textbox (or
after it's entered, reformat it):

textbox1.text = format(date, "mm/dd/yyyy")

or

if isdate(textbox1.text) then
textbox1.text = format(textbox1.text, "mm/dd/yyyy")
end if

Mcasteel wrote:

I want to create a "mask" for my text box, but Im not sure how, I dont
see a clearly labled property for this.

I simply want the text box to show as a Date format:

"__ / __ / ____"

Does anyone know the best way to do this?

Thank you.

--
Mcasteel
------------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698
View this thread: http://www.excelforum.com/showthread...hreadid=275787

--

Dave Peterson