I have a code which works fine in respect of sending values from my userform to my worksheet.
However there is one issue.
TextBox4 on my userform is expecting a post code to be entered.
Once i transfer values to worksheet this post code should be placed into the cell at column D
What actually is pasted into this cell is 0 "zero"
Here is the code that relates to it.
Changing Case 3 to -1 does the trick BUT what is it there for to start with ?