#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Input Box Question

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default Input Box Question

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Input Box Question

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Have user input converted to uppercase in same cell as input? Shannonn New Users to Excel 1 June 20th 06 04:19 AM
How can I have an input form to add a random no. to each input entry? saziz Excel Discussion (Misc queries) 2 January 26th 06 12:46 AM
How do I add input data in the input ranges in drop down boxes. oil_driller Excel Discussion (Misc queries) 1 November 9th 05 11:31 PM
user input question BLW Excel Discussion (Misc queries) 2 May 23rd 05 09:41 PM
=SUMIF(Input!H2:H718,AZ19,Input!E2:E685)AND(IF ALex Excel Worksheet Functions 2 March 14th 05 10:19 PM


All times are GMT +1. The time now is 11:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"