PC Review


Reply
Thread Tools Rate Thread

Changing case in a cell

 
 
wagee@btinternet.com
Guest
Posts: n/a
 
      9th Mar 2008
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
 
Reply With Quote
 
 
 
 
wagee@btinternet.com
Guest
Posts: n/a
 
      9th Mar 2008
On Mar 9, 3:57*pm, wa...@btinternet.com 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!
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing Case in a Cell JimS Microsoft Excel Discussion 7 27th Aug 2008 07:20 PM
Changing multiple cell text from lower case to upper case Patti Microsoft Excel Misc 2 4th Jan 2008 08:35 PM
Can't find short cut for changing case ... upper case .... lower case JERRY Microsoft Word New Users 7 23rd Aug 2007 05:29 PM
Changing Case in a Portion of a Cell Bob H Microsoft Excel Discussion 5 15th Aug 2006 11:13 PM
Changing existing lower case text to upper case Tnd57 Microsoft Word Document Management 4 28th May 2004 12:38 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:11 PM.