+ Reply to Thread
Results 1 to 5 of 5

Textbox - numbered/bulleted list ?

  1. #1
    Forum Contributor
    Join Date
    02-09-2014
    Location
    Kamnik, Slovenia
    MS-Off Ver
    Excel 2010
    Posts
    693

    Textbox - numbered/bulleted list ?

    Hello,

    I have this code for adding cell values to textbox :

    Please Login or Register  to view this content.
    I want to add numbered list in front of values, example :

    1. Data
    2. Data1
    3. Data2 etc.

    Any other character symbol like bullets would be nice too. How can I do this ?

  2. #2
    Valued Forum Contributor
    Join Date
    10-05-2014
    Location
    Regina, SK Canada
    MS-Off Ver
    Excel for Mac 11
    Posts
    330

    Re: Textbox - numbered/bulleted list ?

    To number the lines, use a variable that increases by one each time the case is is "P"…
    See the added parts shown in red.

    Please Login or Register  to view this content.
    If this has been helpful, please click on the star at the left.

  3. #3
    Forum Contributor
    Join Date
    02-09-2014
    Location
    Kamnik, Slovenia
    MS-Off Ver
    Excel 2010
    Posts
    693

    Re: Textbox - numbered/bulleted list ?

    Thanks Stucram, It works great

    Any idea on how to insert a text before this values, on textbox, and that It doesn't repeat with new value ?

    Example :

    THIS IS HEADER

    1. Data1
    2. Data2 etc. ??

  4. #4
    Valued Forum Contributor
    Join Date
    10-05-2014
    Location
    Regina, SK Canada
    MS-Off Ver
    Excel for Mac 11
    Posts
    330

    Re: Textbox - numbered/bulleted list ?

    Quote Originally Posted by Lukael View Post
    Thanks Stucram, It works great

    Any idea on how to insert a text before this values, on textbox, and that It doesn't repeat with new value ?

    Example :

    THIS IS HEADER

    1. Data1
    2. Data2 etc. ??
    Perhaps something like this: (New code shown in red)

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    02-09-2014
    Location
    Kamnik, Slovenia
    MS-Off Ver
    Excel 2010
    Posts
    693

    Re: Textbox - numbered/bulleted list ?

    Thanks man !!

+ 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. Trimming Bulleted list from .docx file leaves symbols
    By cworkman123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-10-2015, 12:52 PM
  2. Combine cells of portions of a numbered list into a continous numbered list
    By AusTempest in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-17-2014, 01:55 AM
  3. Automatic bulleted list not created even though tab checked
    By drajanm in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 05-23-2013, 02:59 AM
  4. creating a bulleted list in a Word document
    By perducci in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-03-2012, 04:21 PM
  5. Reference a userform numbered textbox in vba
    By Khaos176 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-26-2009, 10:04 AM
  6. Populating bulleted list in word.
    By ChrisMattock in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-05-2007, 04:12 AM
  7. [SOLVED] How do I create a bulleted list text format inside cell?
    By DEH in forum Excel General
    Replies: 5
    Last Post: 02-01-2005, 04:06 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