Issue with range selection within user form

New to VBA, looking for a few pointers. I created a simple user form that takes the selected range of names, asks what case (lower/upper/proper), and formatts them accordingly. However, what I have noticed is that the sub initially behaves correctly but when i run it again the selection defaults to the entire worksheet and moidified all text cells:

Please Login or Register  to view this content.

Any suggestions as to why? Even if i subsequently enter more text, select new cells, and run the sub again the default selection is all text, rather than my selection.

Thank you for any help

Try this:

Please Login or Register  to view this content.

Thanks for the help, I appreciate it. However, as I am pretty new to VBA I am more interested in insight as to why this didnt work as I intended. Honestly, I have no actual need for this sub I just wanted to see if it would work. I got it directly from a coding example following a chapter on user forms and what bugs me is that if I go to the site and download the original author's sample code it works as intended while mine, despite that it is identical, does not seem to work exactly right....Any ideas as to why? Could I have some workbook setting that I am unaware of that is throwing things off?
Thanks again!

Anyone? I know this is simple but help is appreciated