I need help, I need to create a user form that opens from the click of a command button and does the
It asks the user for the following information:
initials - This data goes to cell k35
surname - data goes to cell l35
national insurance number - data goes to cell m35 (format must be Letter, letter, number,number,number,number,number,number,
On caseload? - data is "yes or "No" and goes to cell n35
Parent? - data is again "Yes" or "No" and goes to cell O35
Benefit Type - data is "JSA" or "IS" or "IB" or "IS/IB" and goes to cell P35
Then lastly it asks for the clients postcode to be entered but must match this format
(letter,letter,number,space,number,letter,letter) before the space i would like it to have the option of Letter, letter,
number number. if possible.
Once they click "OK" i would like this data copied to the relevant cells and then the
form is cleared. The they have the option of adding another row of data to the next empty row (row36) or exiting.
Can this be done and how???
many thanks you clever people