+ Reply to Thread
Results 1 to 3 of 3

case if combo box, add text, paragraph & style

  1. #1
    Forum Contributor
    Join Date
    10-09-2012
    Location
    Adelaide, South Australia
    MS-Off Ver
    Excel 2010
    Posts
    135

    case if combo box, add text, paragraph & style

    hello Word forum peeps,

    I was hoping someone could help me with this code?
    when the combo box cmbEnclosure = "Yes" I would like to input the text "Encolosure: " and then a paragraph (this paragraph should be using the style "Heading 5"; bot not the text above)
    If cmbEnclosure does not = "Yes" just text should be entered into the document
    curently giving me a 'false' value in the document "Enclosure: (Nil)"

    Please Login or Register  to view this content.
    Thanks

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: case if combo box, add text, paragraph & style

    Your Select Case code is horribly incomplete. That said, try something along the lines of:
    Please Login or Register  to view this content.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Forum Contributor
    Join Date
    10-09-2012
    Location
    Adelaide, South Australia
    MS-Off Ver
    Excel 2010
    Posts
    135

    Re: case if combo box, add text, paragraph & style

    Thanks Paul

+ 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. Replies: 1
    Last Post: 11-08-2013, 04:16 AM
  2. [SOLVED] Changing case to English Style in a Macro
    By jshaw82 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-19-2013, 02:52 PM
  3. Changing Font Style for COMBO BOX
    By nenadmail in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-07-2012, 08:48 AM
  4. Paragraph formatting text
    By rebbrann in forum Excel General
    Replies: 1
    Last Post: 03-04-2007, 01:23 PM
  5. [SOLVED] How do I add (auto text) to a paragraph?
    By Lisa Nelson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-04-2005, 12:06 PM

Tags for this Thread

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