Formatting a Calendar Entry using Forms VBA

nkw2306

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

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
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
18
If I said I was blonde would this explain it!! Lol Thank you. I'll give it a go!
 

Watch MrExcel Video

Forum statistics

Threads
1,090,077
Messages
5,412,216
Members
403,423
Latest member
fori_gump

This Week's Hot Topics

Top