Hi I have a macro which is doing only half the job. I would like to take it
one step further by having the macro select the date from a combo box. The
date of the file is stored in cell A6 and is reflected as
=PISampDat($B$5,"10/30/2009","10/31/2009","5 M", 1,"ps-mon-pi"
Right now when I run my macro it just selects the range and a combo
box/dialogue box pops up. The combo box has a couple of toggle buttons and a
few drop down lists. However the only thing I select in my combo box is the
date, which I change to select the next day, ex.in this case, 10/31/2009 (box
1) and 11/01/09 (box 2).
Is it possible to put in a code that would automatically put in the next
days date relative to the one stored in cell A6?

thnks,

Here's the macro:

Sub PIUpdate()
'
' PIUpdate Macro
' Daily update of PI data
'

'
Application.Run "showSampDat"
End Sub