I'm trying to create an input box that asks the user to input a date. I want
to use that input date for a filter. I can make the input box and enter the
date, however, what the filter reads is the name of the box, not the data
that's input into it. (For example, I said AgingDate = InputBox (InputTitle,
InputMsg) and when I looked at the filter after the macro ran, the filter had
"AgingDate" instead of the actual input date)

Preferably, I want to use the input date minus 60 days as my filter
criteria, if that can be done. So if 3/9/07 was entered, the filter would say
<= 1/8/07.

What am I doing wrong?

Thanks for the help,

Chris

It's hard to say what you're doing wrong, as you don't say what you're
doing, at least with respect to filtering.

How are you applying the filter? Your statement looks like it's adequate
to put a date into the variable, but you don't say how you use that
variable in the filter process.


In article ,
StGermain wrote:

I'm trying to create an input box that asks the user to input a date. I want
to use that input date for a filter. I can make the input box and enter the
date, however, what the filter reads is the name of the box, not the data
that's input into it. (For example, I said AgingDate = InputBox (InputTitle,
InputMsg) and when I looked at the filter after the macro ran, the filter had
"AgingDate" instead of the actual input date)

Preferably, I want to use the input date minus 60 days as my filter
criteria, if that can be done. So if 3/9/07 was entered, the filter would say
<= 1/8/07.

What am I doing wrong?

Thanks for the help,

Chris

here's an example of what I've done. I recorded the inital macro then used
the edit feature to add the input Box. the box pops up okay, but it just
doesn't use the inputted information in my filter, even though I changed the
filter criteria to equal the name of the Input Box.

I'm very new to VBA, and I appreciate all your help.

Chris

"JE McGimpsey" wrote:

It's hard to say what you're doing wrong, as you don't say what you're
doing, at least with respect to filtering.

How are you applying the filter? Your statement looks like it's adequate
to put a date into the variable, but you don't say how you use that
variable in the filter process.


In article ,
StGermain wrote:

I'm trying to create an input box that asks the user to input a date. I want
to use that input date for a filter. I can make the input box and enter the
date, however, what the filter reads is the name of the box, not the data
that's input into it. (For example, I said AgingDate = InputBox (InputTitle,
InputMsg) and when I looked at the filter after the macro ran, the filter had
"AgingDate" instead of the actual input date)

Preferably, I want to use the input date minus 60 days as my filter
criteria, if that can be done. So if 3/9/07 was entered, the filter would say
<= 1/8/07.

What am I doing wrong?

Thanks for the help,

Chris