Hi Anyone,
I have a textbox in my userform with the name txtStaffID. what I want is when the form is loaded the textbox txtStaffID to be visible with the Staff ID number.
Say if I write the Staff ID as 1 in the textbox txtStaffID, I want the number to be S0001.
When I click the Ok button in my form I want the number to automatically change to S0002 and so on.
Any help would be greatly appriciated.
Thanks in advance.
Cheers
Fiza