Formatting a Calendar Entry using Forms VBA

[nkw2306]

Hi.

The date the Monthview brings back onto my sheet is not recognised as a date. So when I try to look up the date to name the tab it isn't recognised. I have tried the following

Selection.NumberFormat = "DD/MM/YYYY"

And

Application.SendKeys "{F2}", True
Application.SendKeys "{ENTER}", True



Cells(emptyRow, 8).Value = TextBox6.Value is where it's bringing back the date but it's in text format or something. So I tried to format this to no avail.

Please someone help?

 

[James006]

Hello,

Your TextBox is holding ... well Text ...

In order to get a Value ...

You should test CDate(TextBox6.Value)

Hope this will help

 

[nkw2306]

If I said I was blonde would this explain it!! Lol Thank you. I'll give it a go!

 

[James006]

If I said I was blonde would this explain it!! Lol Thank you. I'll give it a go!

Blonde AND Sexy ... !!!

You are welcome ...