Call AutoFilter function through VBA?

[CyberJar]

Can I call the AutoFilter function programatically with VBA to work on Form data - rather than using it on a Worksheet?

Or better yet, While focus is on a form, can I call AutoFilter to work on a Worksheet containing data?

Also when do you use the Worksheet object and when do you use the Sheets object?

Thanks,
CJ

[BrianB]

>Can I call the AutoFilter function programatically with VBA to work on Form data - rather than using it on a Worksheet?
-
No
'-------------------------------------------------------------------------
>Or better yet, While focus is on a form, can I call AutoFilter to work on a Worksheet containing data?
'-
Yes. I suggest you use the macro recorder to get started.
'----------------------------------------------------------------------------
>Also when do you use the Worksheet object and when do you use the Sheets object?
'-
Interesting question. I do not know of any difference in usage.
'-------------------------------------------------------------------------

[CyberJar]

Thank you for your responses Brian.

CJ