Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
How can I have an input form to add a random no. to each input entry? | Excel Discussion (Misc queries) | |||
How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
user input question | Excel Discussion (Misc queries) | |||
=SUMIF(Input!H2:H718,AZ19,Input!E2:E685)AND(IF | Excel Worksheet Functions |