VBA Post the value "as it is"

Question

I am typing in my textbox in excel following: 2017-01-09 the result posted in the cell is 42744

What am I doing wrong here even do I am specifically saying that my cell should be formatted as a 'general' type

Private Sub TextBox2_LostFocus()
        Range("F3").Value = TextBox2.Value
        Range("F3").NumberFormat = "General"
        Range("F3").Select
        Application.SendKeys ("~")
        Range("F3").NumberFormat = "General"
End Sub

The general number format shows the underlying value of a date. If you want to show the actual date, then use a date-style number format. — Phylogenesis, Jan 20 '17 at 11:09
that is it if you like you can post as an answer so easy thnaks for your effort — Niko.K, Jan 20 '17 at 11:15
Probably useful reading for you: [Excel VBA date formats](https://stackoverflow.com/questions/19801598/excel-vba-date-formats/19809413#19809413) — Jean-François Corbett, Jan 20 '17 at 14:38

score 2 · Answer 1 · answered Jan 20 '17 at 11:15

2

Do it like this:

With Range("F3") 
 .NumberFormat = "yyyy-mm-dd"
 .FormulaR1C1 = "2017-01-09"
End With

answered Jan 20 '17 at 11:15

AnalystCave.com

4,732
2
20
29

score 2 · Accepted Answer · edited Jan 20 '17 at 14:37

2

Here it is -

Range("F3").Value = TextBox2.Text

Range("F3").NumberFormat = "yyyy-mm-dd"

edited Jan 20 '17 at 14:37

Jean-François Corbett

36,032
27
135
183

answered Jan 20 '17 at 11:42

Praveen Behera

416
2
5
13

VBA Post the value "as it is"

2 Answers2