Autofilter a variable?

[JayLee]

I declared a variable in a userform, can I store that variable and then have it do this:

Selection.AutoFilter Field:=4, Criteria1:="=myVar

Would it work?

 

[Yogi Anand]

On 2002-10-07 19:03, JayLee wrote:
I declared a variable in a userform, can I store that variable and then have it do this:

Selection.AutoFilter Field:=4, Criteria1:="=myVar

Would it work?

Hi JayLee:

Try ...

Selection.AutoFilter Field:=4, Criteria1:="" & [myVar] & ""

Please postback if it works for you ... otherwise explain a little further and let us take it from there.

Regards!

Yogi

 

[Juan Pablo González]

On 2002-10-07 19:03, JayLee wrote:
I declared a variable in a userform, can I store that variable and then have it do this:

Selection.AutoFilter Field:=4, Criteria1:="=myVar

Would it work?

I don't mean to be rude, but, have you tried it ?

 

[JayLee]

Nope, I tried it. It doesn't work. What happens is, it autofilters and nothing comes up. Basically, the autofilter isn't picking up the variable. Can anyone help with this?

 

[JayLee]

Here is some code to help explain myself more:

Private Sub cmdOk_Click()
Dim CurrentDate As Date
ActiveCell = cbDate.Value
ActiveCell = CurrentDate
Call DateSelect
End Sub

That's on the form.
What happens is that it doesn't seem like it's assigning the selected value to the variable, CurrentDate. I'm perhaps screwing something up here. The cbDate works perfectly displaying nonduped dates. Can some one help me with this? This is the last part of my huge project and I hope I can get this last part working! Thanks so much for everyone's help!!!!

 

[JayLee]

I figured it out, basically, I had to make the variable global like this:

Public CurrentDate As Date

So that data can be passed to the other module. Thanks guys for your insights.

 

[Hawk123]

How did you get it to autofilter with a variable criteria. I set my variable public and it still isn't picking it up, its like it isn't recognizing the variable