TextBox Output Format not Same as my Table

The code below works nicely when I want to add items to my table but does not maintain the format to mach all items in the table. All table items are formatted with a Cyan backcolor, Arial Bold size 10 font, and the date is formatted as number (mmm-dd-yy). The output of the text boxes now is White backcolor, Arial regular size 14 and the date is formatted as text (mmm-dd-yy)

The 4 text boxes in my userform are formatted as per above except for the date which I have no way to format as number. Another Forum member has provided the code for the “txtDate.Value” shown in the code but this outputs the date as text and not as number. The txtDate must be formatted as number otherwise sorting the Date column by Date does produce the required results

Is there any way to have these text boxes formatted to mach my table format?

Please Login or Register  to view this content.

They both work, thanks but they only format the day as number which is part of what I want and the font size / type / backcolor remains unchanged. Any idea how I can maintain the format to match the formats in my table?

Formating the column does not help in my case (output of all text boxes is always with white background and different font) but reading on the web I found a page in a Microsoft forum which says:

"The textbox does not have a built-in property that stores the 'underlying value'. You will need to store that value in a separate variable or you could make use of the .Tag property. Either way you will need to maintain the relationship between value and display of value.
txtPercent.Tag = 0.992
txtPercent.Text = Format(txtPercent.Tag,"0.0%")"

So in my case can someone tell me how to use this Tag property?