Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing inputbox input to worksheet
I have the following code
Private Sub cmdUpdateSummary_Click() Dim StartDate As Date Dim EndDate As Date StartDate = InputBox("Enter Starting Date Please", StartDate) EndDate = InputBox("Enter Ending Date Please", EndDate) End Sub Can anyone tell me how i can collect the dates in between those entered from a worksheet and place them on a new worksheet? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing inputbox input to worksheet
Hi SDH,
Yoo could use Excel's Advanced Filter to extract and copy the data to the required sheet. Try turning on the macro recorder while you perform the requisite steps manually. This will provide you with base code which may be edited to render it more generic and to replace the date criteria with the results of your input boxes. If you are not familiar with the Advanced Filter, see Debra Dalgleish's tutorial at: Excel -- Filters -- Advanced Filters -- Introduction http://www.contextures.com/xladvfilter01.html --- Regards, Norman "SDH" wrote in message ... I have the following code Private Sub cmdUpdateSummary_Click() Dim StartDate As Date Dim EndDate As Date StartDate = InputBox("Enter Starting Date Please", StartDate) EndDate = InputBox("Enter Ending Date Please", EndDate) End Sub Can anyone tell me how i can collect the dates in between those entered from a worksheet and place them on a new worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check on the input in an inputbox | Excel Programming | |||
Numerical Input via an inputbox method | Excel Programming | |||
Numerical Input via an inputbox method | Excel Programming | |||
Check on the input in an inputbox | Excel Programming | |||
String length of Inputbox user input. | Excel Programming |