View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] wagee@btinternet.com is offline
external usenet poster
 
Posts: 16
Default Changing case in a cell

Hi guys, I have looked around a bit and don't see a macro/VB code that
will do what I like. I have a textbox that users can enter text and
numbers into such as mpl024. Right now they can enter either lower or
upper case letters.

I would like to limit the input to upper case letters or run a VBA
that would change the first 3 letters to upper case.

Any suggestions? New to VBA but been around Excel for quite a
while....

Thanks

Wayne