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

[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?

 

[Steve]

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?

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.

 

[mulehead]

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.

 

[Steve]

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 -

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?

 

[mulehead]

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.