+ Reply to Thread
Results 1 to 9 of 9

Convert text in textbox as i type

  1. 06-22-2011, 12:35 AM #1
    pblnrao
    pblnrao is offline
    Registered User
    Join Date
    05-18-2010
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003, 2007, 2013 Prof Plus
    Posts
    42

    Thumbs up Convert text in textbox as i type

    Hi All,

    I have form to enter data. what i need is, when the user type the string then it should automatically change the test to proper case as i type.

    Ex :

    test - > Test (as i type 2nd letter "e" in the word "test" then the first letter "t" should change to "T" and rest to be lowercase. The final result should be "Test" even if i type "tEsT"

    Hope i will get the solution as soon as possible.....
    Last edited by pblnrao; 06-22-2011 at 03:28 AM. Reason: Solved
    Reply With QuoteRegister To Reply
  2. 06-22-2011, 12:42 AM #2
    Mordred
    Mordred is offline
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Convert text in textbox as i type

    I don't think you will be able to do what you want "as you type".
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---
    Reply With QuoteRegister To Reply
  3. 06-22-2011, 12:53 AM #3
    Mordred
    Mordred is offline
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Convert text in textbox as i type

    You can always have an adjacent cell do the editing for you by adding this to it:
    =Proper(A1)

    A1 is a representation of what ever cell you want to edit.
    Reply With QuoteRegister To Reply
  4. 06-22-2011, 01:00 AM #4
    pblnrao
    pblnrao is offline
    Registered User
    Join Date
    05-18-2010
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003, 2007, 2013 Prof Plus
    Posts
    42

    Re: Convert text in textbox as i type

    Its not that the data will be entered excel cells...

    I will have a VBA form for data entry.... there in that text box i want this to happen....
    Reply With QuoteRegister To Reply
  5. 06-22-2011, 01:18 AM #5
    Mordred
    Mordred is offline
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Convert text in textbox as i type

    Sorry for not reading properly.
    Reply With QuoteRegister To Reply
  6. 06-22-2011, 02:21 AM #6
    john55
    john55 is offline
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Convert text in textbox as i type

    hi,
    not sure but try this one
    Please Login or Register  to view this content.
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-
    Reply With QuoteRegister To Reply
  7. 06-22-2011, 02:43 AM #7
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Convert text in textbox as i type

    Hello pblnrao,

    A little tweak to the last post...
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  8. 06-22-2011, 03:28 AM #8
    pblnrao
    pblnrao is offline
    Registered User
    Join Date
    05-18-2010
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003, 2007, 2013 Prof Plus
    Posts
    42

    Thumbs up Re: Convert text in textbox as i type

    Thx John & Leith......

    worked xctly hw i xpcted...

    Quote Originally Posted by Leith Ross View Post
    Hello pblnrao,

    A little tweak to the last post...
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 06-22-2011, 03:37 AM #9
    snb
    snb is offline
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Convert text in textbox as i type

    The more robust code:

    Please Login or Register  to view this content.

    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1