I'm sure this is quite simple and I am rather annoyed with myself that I can't get it to work but, I can't!
I have a table (Table9) in sheet (Trained Staff) which is formatted as an excel table with headers. The relevant of those headers for this bit being "Issuer" and "Authority status".
I also have a UserForm (UFAddEntry) with a text box (TxtIssuer) and I just want to look through the data in Table9 for the value in the textbox (in the Issuer column) and if the value in the 'Authority status' column is anything other than "Active" then to give me a messagebox with what the 'Authority status' value is.
Can anyone assist please. Thanks in advance.
I have a table (Table9) in sheet (Trained Staff) which is formatted as an excel table with headers. The relevant of those headers for this bit being "Issuer" and "Authority status".
I also have a UserForm (UFAddEntry) with a text box (TxtIssuer) and I just want to look through the data in Table9 for the value in the textbox (in the Issuer column) and if the value in the 'Authority status' column is anything other than "Active" then to give me a messagebox with what the 'Authority status' value is.
Can anyone assist please. Thanks in advance.