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?

On May 21, 10:09*am, mulehead
wrote:
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.

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" wrote:

On May 21, 10:09 am, mulehead
wrote:
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.

On May 21, 11:19*am, mulehead
wrote:
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" wrote:
On May 21, 10:09 am, mulehead
wrote:
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.- Hide quoted text -

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

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.

"Steve" wrote:

On May 21, 11:19 am, mulehead
wrote:
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" wrote:
On May 21, 10:09 am, mulehead
wrote:
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.- Hide quoted text -

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