Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates from InputBox
Hello,
I am having a problem with the following code. When the user inputs the date in mm/dd/yyyy format in the inputbox, it gets converted into a number (9 for example) and displays 1/8/1900 in the cell. Could someone suggest how to force the inputbox to use the needed date format? Jon Private Sub Workbook_Open() aDate = Range("A1").Value Ans = MsgBox("Is " & aDate & " the correct reconciliation date?", vbYesNo, "Question...") Select Case Ans Case vbYes Exit Sub Case vbNo Prompt = "What is the new reconciliation date?" Caption = "Tell me..." newrecDate = Val(InputBox(Prompt, Caption)) Range("A1") = newDate End Select End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates from InputBox
Jon,
dim newrecDate = date newrecDate = InputBox(Prompt, Caption) Range("A1") = newrecDate I assume range("A1") is formatted for dates. Ross "Jon" wrote in message ... Hello, I am having a problem with the following code. When the user inputs the date in mm/dd/yyyy format in the inputbox, it gets converted into a number (9 for example) and displays 1/8/1900 in the cell. Could someone suggest how to force the inputbox to use the needed date format? Jon Private Sub Workbook_Open() aDate = Range("A1").Value Ans = MsgBox("Is " & aDate & " the correct reconciliation date?", vbYesNo, "Question...") Select Case Ans Case vbYes Exit Sub Case vbNo Prompt = "What is the new reconciliation date?" Caption = "Tell me..." newrecDate = Val(InputBox(Prompt, Caption)) Range("A1") = newDate End Select End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates from InputBox
Ross-Thanks! Only 1 minor adjustment
dim newrecDate As Date Thanks again- Jon "Ross Culver" wrote: Jon, dim newrecDate = date newrecDate = InputBox(Prompt, Caption) Range("A1") = newrecDate I assume range("A1") is formatted for dates. Ross "Jon" wrote in message ... Hello, I am having a problem with the following code. When the user inputs the date in mm/dd/yyyy format in the inputbox, it gets converted into a number (9 for example) and displays 1/8/1900 in the cell. Could someone suggest how to force the inputbox to use the needed date format? Jon Private Sub Workbook_Open() aDate = Range("A1").Value Ans = MsgBox("Is " & aDate & " the correct reconciliation date?", vbYesNo, "Question...") Select Case Ans Case vbYes Exit Sub Case vbNo Prompt = "What is the new reconciliation date?" Caption = "Tell me..." newrecDate = Val(InputBox(Prompt, Caption)) Range("A1") = newDate End Select End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to enter dates in Excel cells using InputBox | Excel Programming | |||
InputBox requesting dates between two predefined dates | Excel Programming | |||
How do I get dates into an inputbox ? | Excel Programming | |||
Entering dates in vba inputbox as ddmmyy. Excel returns mmddyy | Excel Programming | |||
Inputbox and Application.InputBox | Excel Programming |