I have data in range J2:J365 , H368:H401 & J403:J827
i want to check wether this range have negative values or not if yes load all negative values in the listbox1 by clicking checkbox

if any one could help me please

Naeem