View Single Post
  #2   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

On Mar 9, 3:57*pm, wrote:
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


Never mind guys on doing a little bit more digging I found what I
needed. Thanks!