Help, how do you open dialog box to filter a column

  • Thread starter Thread starter mulehead
  • Start date Start date
M

mulehead

Help, how do you open dialog box to filter a column so date can be selected
or is there a better way to do this?
 
Help, how do you open dialog box to filter a column so date can be selected
or is there a better way to do this?
Click to expand...

If I am understanding you want to filter data within the spreadsheet
from values within a column. If this is true than you can autofilter
(Data, Filter, Autofilter). Does this answer your question.
 
No,

I need the capability to run a macro that will open a dialog box or can use
a drop down box to filter on a the desired date.
 
No,

I need the capability to run a macro that will open a dialog box or can use
a drop down box to filter on a the desired date.






- Show quoted text -
Click to expand...

Can you explain further? You have a spreadsheet with data. You want to
press a button and a dialog box will appear. In that dialog box you
want to enter a date. From that date you want to filter records? Is
this correct?
 
Steve, I want to add some code to a macro that will open a dialog box or a
drop down window and you can select a date, once the date is selected, then
column "A" with dates will filter on that date. I hope this helps....thanks
Steve.
 
Back
Top