Giving the user the option to amend a portion of a fixed formula before macro is run

[Gti182]

hi all,

I have a bit of code which inserts 2 formula's into cells which i then use as criteria for a sort/filter.
Currently it filters 2 date columns to include all dates between today's date and 3 months into the future.

It now seems users might want to see dates further into the future e.g. 5 months. Is it possible to give the user the option on how many months into the future they can filter?

edit: perhaps something like an input box?

Please Login or Register  to view this content.

[millz]

If the formula is working as intended, try this:

Please Login or Register  to view this content.

[Fotis1991]

Hello

You can give to your userd the ability to type IN A CELL(or to choose using a validation list) the number of months that they need to see and use this cell reference in your code. Let's say in cell P1.

Please Login or Register  to view this content.

[Gti182]

MILLZ!!! Thats a beautiful thing!! works great

thanks FOTIS yours works too

[Fotis1991]

You are welcome and thanks for the feed back.