Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro Prompting
I created an Excel macro to update a worksheet on a monthly basis. The macro
prompts for the Start and Stop dates using the InputBox Method. The problem I'm having is that the date values will not occupy the designated cells. The following is what I created: Dim dtestart As Date dtestart = InputBox("ENTER START DATE FOR THIS CDRL PERIOD: MM/DD/YYYY") Worksheets("Configuration").Range("b6").Formula = "dtestart" Dim dtestop As Date dtestop = InputBox("ENTER START DATE FOR THIS CDRL PERIOD: MM/DD/YYYY") Worksheets("Configuration").Range("b7").Formula = "dtestop" Instead of the dates being input into cells b6 and b7, the strings "dtestart" and "dtestop" are entered. Please help! The date (example: 05/31/2008 ) needs to occupy the cell after it is input. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Examples for prompting info | Excel Programming | |||
Save file without prompting in Excel Macro | Excel Programming | |||
Excel Macro Save CSV Cell without Prompting | Excel Discussion (Misc queries) | |||
Prompting 'Save As' in an Excel Macro | Excel Programming | |||
Prompting a macro to run on change of cell content | Excel Programming |