events
 

Hi,

I have little problem with event (Worksheet_Change), which
will take value from specific textbox and do selection in
autofilter.

Selection.AutoFilter Field:=1, Criteria1:= TextBox1.Value

I don't know VBA well.
How to write code?

Many thanks in anticipation!
MArk

events
 

I manage it:
Event:

Sub Texbox1_Change ....

Regards
Mark

-----Original Message-----
Hi,

I have little problem with event (Worksheet_Change),
which
will take value from specific textbox and do selection in
autofilter.

Selection.AutoFilter Field:=1, Criteria1:= TextBox1.Value

I don't know VBA well.
How to write code?

Many thanks in anticipation!
MArk

.