A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Date query "Excel VBA"



 
 
Thread Tools Display Modes
  #1  
Old August 4th, 2004, 08:38 AM
avilla
external usenet poster
 
Posts: n/a
Default Date query "Excel VBA"

Is there anyway i can use vba code to create a user input box on a sales
worksheet that will filter the sales orders and only display the orders
that equal the date entered into the input box by the end user.

I am already using the autofilter feature but would like to take it one
step further and make it easier for the admin clerk.

Thank-You


---
Message posted from http://www.ExcelForum.com/

  #2  
Old August 4th, 2004, 11:53 PM
Dave Peterson
external usenet poster
 
Posts: n/a
Default Date query "Excel VBA"

You didn't like yesterday's suggestion????

http://groups.google.com/groups?thre...0CDD%40msn.com



"avilla " wrote:

Is there anyway i can use vba code to create a user input box on a sales
worksheet that will filter the sales orders and only display the orders
that equal the date entered into the input box by the end user.

I am already using the autofilter feature but would like to take it one
step further and make it easier for the admin clerk.

Thank-You

---
Message posted from http://www.ExcelForum.com/


--

Dave Peterson

  #3  
Old August 13th, 2004, 01:58 PM
avilla
external usenet poster
 
Posts: n/a
Default Date query "Excel VBA"

Hi

Sorry, have not been on the forum for a couple of days and did not see
the post. Had a look and before giving it at try it looks exactly what
i have been trying to acheive.


---
Message posted from http://www.ExcelForum.com/

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
query wizard error Christen General Discussion 12 August 13th, 2004 08:37 PM
when import EXCEL to ACCESS, the date format excel column title changed... Amolin General Discussion 6 June 25th, 2004 08:56 AM
Date Query PPerry Running & Setting Up Queries 2 June 5th, 2004 03:01 PM
MS Query in Excel Paul New Users 5 May 21st, 2004 03:49 PM
Does date fall between two ranges? MR Worksheet Functions 4 January 14th, 2004 04:08 PM


All times are GMT +1. The time now is 03:04 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.