I have a Userform which will bring up the last value that was entered in column E. 

This is good, however I would like the userform to show the last value increased by one, saving the user from having to change the value themselves.

E.g.

"MSA 00-00-0001" <-This is whats shown, as this is the last value in the column
However I would like the userform to show MSA 00-00-0002

Normally you would just use .Value + 1 I'm assuming, however this won't work due to the hyphens and the Text in the value field.