Formatting a Calendar Entry using Forms VBA

nkw2306

New Member
Joined
Jan 20, 2015
Messages
15
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

Well-known Member
Joined
Apr 4, 2009
Messages
3,666
Hello,

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

In order to get a Value ...

You should test CDate(TextBox6.Value)

Hope this will help
 

nkw2306

New Member
Joined
Jan 20, 2015
Messages
15
If I said I was blonde would this explain it!! Lol Thank you. I'll give it a go!
 

Forum statistics

Threads
1,078,226
Messages
5,338,958
Members
399,272
Latest member
jakepenner

Some videos you may like

This Week's Hot Topics

Top