+ Reply to Thread
Results 1 to 5 of 5

VBA to extract the first letter of every word in userform textbox

  1. #1
    Registered User
    Join Date
    03-01-2018
    Location
    Philippines
    MS-Off Ver
    2003,2007,2010,2013 and 2016
    Posts
    51

    VBA to extract the first letter of every word in userform textbox

    Good day!

    Does anyone can do vba coding to extract the first letter of every word in the userform textbox?
    I have a textbox value = The New State University of Negros Island. I need only TNSUoNI. This will be copied to the worksheet cell A2.

    Thank you and more power to all.

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: VBA to extract the first letter of every word in userform textbox

    Please Login or Register  to view this content.
    kind regards
    Leo

  3. #3
    Registered User
    Join Date
    03-01-2018
    Location
    Philippines
    MS-Off Ver
    2003,2007,2010,2013 and 2016
    Posts
    51

    Re: VBA to extract the first letter of every word in userform textbox

    Quote Originally Posted by LeoTaxi View Post
    Please Login or Register  to view this content.
    kind regards
    Leo
    Thank you Leo. I have added a code inside
    Please Login or Register  to view this content.
    The code you have provided displayed NSUoNI only. But the whole idea was great.

    Thank you so much.

  4. #4
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,293

    Re: VBA to extract the first letter of every word in userform textbox

    Change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: VBA to extract the first letter of every word in userform textbox

    you missed post #4 from Nigelog

    just change the 1 to 0 in the for i loop is the right solution

    Kind regards
    Leo

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Extract Two Letter Word from Text in Cell
    By alyon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-02-2018, 11:30 AM
  2. [SOLVED] Capitalize each word in Textbox in Userform
    By Axmed.cm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-23-2016, 01:58 AM
  3. Choose multiple Word-Documents via UserForm TextBox and combine them to Master Word-Doc
    By ODeveloper in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-15-2015, 09:25 AM
  4. [SOLVED] How to extract single letter from the whole word in excel
    By Vimal Bhatt in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-21-2015, 11:25 AM
  5. Excel userform to Word template letter with bookmarks
    By scottiec21 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-09-2014, 09:22 AM
  6. [SOLVED] Userform Textbox will not allow capital letters after first letter input
    By Stratfordoaks in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-20-2014, 10:07 AM
  7. Word wrap in Textbox of Userform
    By ChemistB in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-05-2011, 10:53 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1