I have a TextBox (TextBox7) in a UserForm (START_A_JOB) that people input there initials into. When they click a button i would like to refer to a Table (Table3) on Sheet (AVAILABILITY) to check that they don't already have a job open.
Below is a capture of the table and the code that i am currently using witch works fine, but i would like to simplify the code and make it so that if a new person joins of if someone leaves then i just have to edit the table instead of editing the code.
On the table the Open Job and Total Job columns are automatically updated and also works fine.
Capture.JPG
Bookmarks