Hi can anyone help me with some vba.

I have a column in a spreadsheet column T that has positive and negative values, I want to count how many consecutive negative numbers before there is a positive number.

This will happen more then once so for example 7 negative numbers before a positive number.
Then 10 negative numbers before a positive number

I need to write the answers in column V for example
7
10