Hi
how Using the function "countifs" in VBA ?
Hi
how Using the function "countifs" in VBA ?
You need to be a bit more specific than that.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I found myself
TextBox5.Text = WorksheetFunction.CountIfs(Sheet1.Range("b:b"), TextBox2.Text, Sheet1.Range("f:f"), (">=" & TextBox3.Text), Sheet1.Range("f:f"), ("<=" & TextBox6.Text))
Are you able to post a sample workbook showing what it is that you are trying to do? I am unable to follow what you are trying to explain at this point.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link