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