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

[Mcasteel]

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.

 

[Dave Peterson]

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