LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Macro to delete rows with cells less than user-inputed time

Hi all,

My knowledge of VBA is very limited. I need help in trying to make a
macro I have do an additional step. I have a column (D) in a worksheet
that is showing time values (2:30 PM, 3:15 PM, etc.). I need to code
the macro so a user can enter a time value and the macro will then
delete any rows in that worksheet in which the corresponding cell in
column D shows a time value LESS THAN the value entered by the user.
I've seen a couple of macros that delete rows matching a string in a
cell but nothing that deletes based on the cell value being less than.
I would appreciate any help you call can offer. Also - I need this to
be done as a macro. I know how to filter the column manually to get
what I want but I need this as a macro so people who are not familiar
with Excel can simply open the workbook (I have the macro set to run
automatically), enter the time value (ex. 2:30 pm) and they'll get all
the rows in which the time is greater than or equal to 2:30 pm (the
rows with an earlier time having been deleted by the macro).

Thanks in advance.
MP

 
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
Date format changes when inputed from user form Lynz Excel Discussion (Misc queries) 16 December 13th 08 11:27 PM
only allow one cell inputed for a range of cells Brian Excel Discussion (Misc queries) 8 October 30th 07 11:30 PM
How do I formate cells in excell to show inputed date as 09/13/ Dave Wentz Excel Worksheet Functions 1 September 14th 06 09:26 AM
VBA: Return Searched Value Inputed by End-User Mcasteel Excel Worksheet Functions 1 October 28th 04 03:09 PM
Macro to delete rows with text cells zsalleh Excel Programming 8 August 27th 04 12:22 AM


All times are GMT +1. The time now is 09:50 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"