read cell under specific criteria

Hi all,

I am under Excel 2003 (VBA of course).
I have a form with 7 labels named: Label7 to Label13.
I have a database with more than 7 rows in (2 cloumns).

What i'd like to do is for my file to automatically find (on the form's upload) when a row has the value "Not Done" in column B and put the value from the cell next to it (column A on the same row) into label7 and then continue and find the next row with value "Not Done" in column B and this time put the value from cell A into Label8.

i'd like it to continue until he completes the 7 Labels or until he can't find anymore rows with the value "Not Done" in column B and then make the remaining labels not visible (using for example label13.visible = False) (if 4 rows with value "Not Done" are found then it should hide the last 3 labels.

Is this possible?

regards,

SimonStart Free Trial