Changing case in a cell

W

wagee

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
 
W

wagee

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
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

auto convert to upper case 1
Combo Box case sensitivity 0
Column All Upper Case 14
Lower case "a" in "application" 5
Good code, need one more step 3
Format Cell - Only Upper Case Alpha characters 3
Lower-Case Characters 2
Upper Case vs. Lower Case Add-Ins 5

Top