Filter data based on combobox value problem

[Ecniv]

Ecniv,

I am just trying to use:

Dim myDateRange As Range
UserForm1.ComboBox1.Value = myDateRange

I defined the range using the insert/define bit on the menu bar.

I dont have a hidden column, at least not deliberately, and the date is currently formatted as: dd/mm/yyyy. Does any of that mean anything?

I have not seen a combo box filled like that... always a first time.
When I do this I usually loop thorugh and add the data to the combo box using additem (or .add). If you read up on these and see if they help...

Once you have a combo box of dates, and you select one, you need to put it somewhere on a sheet so your formulas etc can use it to show the data on a filtered sheet.

I have see this done, but it escapes me how. I think is is if, vlookup and conditional formatting combined creatively.