Find negative numbers in a table and return the value and corresponding text

Hi

Hopefully somebody can guide me in the right direction..

I have a table with 2 columns:

Column A always contains text
Column B always contains numbers
The table does not have a fixed amount of rows and will be continually increasing over time

I want a macro that will search the table from top to bottom for the first set of values with a negative number in column B, then return that set of values (Column A & Column B) to any 2 cells in the spreadsheet (lets say A1 and B1)

So for instance using the attached example the macro will find the values 'Text 2' and '-0.1' and put them into the cells A1 & B1.

If no negative values are found then I want to simply exit the macro.

Thanks in advance!

Sorry I should have made it clear but the reason I need to use VBA is because I have another macro that will copy the negative values to another table then delete them.

I want to combine the 2 together so I can automate the function, as currently the user has to manually enter the values into A1 & B1.

Thanks that should work perfectly, I hadn't heard of the Evaluate function before that should definitely come in handy in future.

I just tried to implement this into my sheet and I noticed that the the IFERROR function doesn't seem to be working (unless I'm doing something wrong?)

Even if all the values in the B column are positive it still returns the top value, not the "No Negatives" string it should do.

Am I missing something?

Perfect, thanks!