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