VBA Help Needed to Format a Textbox for today Date

[sylvainsyl20]

Hi,

I need some help here, I made an excel form that will generate a final quotation that cannot be modified by the user. I have inserted a text box (activeXcontrol) from Developer, and I want it to display today's date. I first tried to make it display the value of a cell, but it converts the date into a number. Since this text box is part of an object, I cannot just use a cell to do this job.

Any suggestion will be much appreciated

Thanks and have a great day

[alansidman]

Try this:

Please Login or Register  to view this content.

[stnkynts]

Assuming your linked cell is A1 and you textbox is named TextBox1

Please Login or Register  to view this content.

[sylvainsyl20]

Thanks for the help on this one,

I tried but this doesn't work, I still end up with a number instead of an actual date format

[alansidman]

I suspect it is a formatting issue. Look at this Link to understand dates and times in Excel

http://www.exceltactics.com/definiti...s-times-excel/

[sylvainsyl20]

Thanks

I will check this one

[Norie]

Where exactly is the textbox located?

Is it on a sheet or a userform?

[sylvainsyl20]

It's on a user form,

I found a way around it, I linked the textbox to a cell, and I placed a formula in the cell to convert today's date into text

Something like

Please Login or Register  to view this content.

[Norie]

All you should need is something like this which would go in the userform's Initialize event.

Please Login or Register  to view this content.

[sylvainsyl20]

Thanks Norie,

I will try this one also