Find dates?

**Pinokkio** · 10-18-2009, 04:37 PM

Is it possible in column C to find dates with the textbox?

Hope you can help me.

**Richard Buttrey** · 10-18-2009, 04:51 PM

Hi,

Why not use a ListBox instead of a TextBox? Then you could name C2:C26 as say 'dates' and put the name 'dates' in the RowSource property of the ListBox.

Rgds

**Pinokkio** · 10-18-2009, 05:03 PM

I have not make this.

Everything depends on the textbox and the listing?

**Richard Buttrey** · 10-18-2009, 06:44 PM

I'm not clear what you're saying.

If you're looking to capture the values from a range so that you can pick one of them from a forms control, then you will need a ListBox (or ComboBox). A TextBox allows anything to be entered which from your description is not what you're trying to achieve.

Rgds

**royUK** · 10-19-2009, 02:46 AM

Your code appears to be trying to autofilter the data, why not just use autofilter

**Pinokkio** · 10-19-2009, 12:35 PM

The signature is xl2003 sorry for that.(have already changed).

I work now with xl2007.

As you can see the first two columns all work very well,
in this example I like to work with column C if it is posible.
With this file is much easier to find.

auto filter is not an option because there are more than 3500 lines.