I've just recently responded to a similar request on another forum.
Whilst my answer there is NOT suitable for your purposes, a solution proposed by Paul_Hossler there does fit your purposes.
Here's the link: http://www.vbaexpress.com/forum/show...another-format
ps. there's one line you might prefer not to have in that code:
.Value = UCase(.Value)


(it capitalises the results).

Hi there,

thanks or your reply, it helped me greatly along the way.

but.. I have a small problem, I need to find a workaround (not using the userform)

I can provide the specified ranges for the userform inputs, yet i cant seem to make it work by rewriting the code,

(the error msgbox keeps popping up)

regards,

Sok