I
inès
Hello
I would like to use an input box to find in my excel data base some
information.
I have been able to create the input box and the vba code to find a word or
the sentence but if i put both together it doesn't work anymore.
Could you please help me.
The code which i have create is as follow:
Sub Find()
Dim rangeCel As Range
Dim compt As Integer
Dim fin As String
fin = Application.InputBox(Prompt:="KUNDE", Type:=2)
ActiveSheet.Range("$A$15:$n$500 ").AutoFilter Field:=1, Criteria1:="=*" &
[H14].Value & "*"
End Sub
Thanks a lot
Inès
I would like to use an input box to find in my excel data base some
information.
I have been able to create the input box and the vba code to find a word or
the sentence but if i put both together it doesn't work anymore.
Could you please help me.
The code which i have create is as follow:
Sub Find()
Dim rangeCel As Range
Dim compt As Integer
Dim fin As String
fin = Application.InputBox(Prompt:="KUNDE", Type:=2)
ActiveSheet.Range("$A$15:$n$500 ").AutoFilter Field:=1, Criteria1:="=*" &
[H14].Value & "*"
End Sub
Thanks a lot
Inès