| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Date from VBA form comes into worksheet as text
In a form I input a date & when it comes across to the excel worksheet it
recognises it as text rather than a date (even though it looks like a date eg in worksheet date looks like 16/06/09. Look forward to your answer. -- Thanks, Butterfly Girl |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Date from VBA form comes into worksheet as text
Make sure its Dim'ed correctly:
Sub OnlyaMoth() Dim d As Date d = Application.InputBox(prompt:="Give me a date", Type:=1) Range("A1").Value = d End Sub -- Gary''s Student - gsnu200857 "ButterflyGirl" wrote: In a form I input a date & when it comes across to the excel worksheet it recognises it as text rather than a date (even though it looks like a date eg in worksheet date looks like 16/06/09. Look forward to your answer. -- Thanks, Butterfly Girl |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Date from VBA form comes into worksheet as text
B-G,
From the form to the worksheet: Worksheets("Sheet Name").Range("A1").Value = DateValue(me.Textbox1.Text) HTH, Bernie MS Excel MVP "ButterflyGirl" wrote in message ... In a form I input a date & when it comes across to the excel worksheet it recognises it as text rather than a date (even though it looks like a date eg in worksheet date looks like 16/06/09. Look forward to your answer. -- Thanks, Butterfly Girl |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 criteria lookup of text. Return text form column 3. SUMPRODUCT t | Excel Worksheet Functions | |||
| How do you convert an uncoded date (e.g., 20080304) to a date form | Excel Worksheet Functions | |||
| Rename worksheet tab as date not text | Excel Discussion (Misc queries) | |||
| DATE IN TEXT FORM - NEED TO CHANGE IT DATE FORM | New Users to Excel | |||
| Using a Worksheet Form to add data to a separate worksheet databas | Excel Worksheet Functions | |||
Linear Mode
