+ Reply to Thread
Results 1 to 3 of 3

Quick question regarding line break within code & variable within prompt box

  1. #1
    Registered User
    Join Date
    05-18-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    59

    Quick question regarding line break within code & variable within prompt box

    Hey all,

    I have 2 questions regarding the prompt box
    1.) How do I create line breaks in the code for easier reading/editing for text between prompt=:" " ?
    2.) How do I reference some text to variables in the prompt?

    Example this is the wrong code that needs to be fixed:

    Please Login or Register  to view this content.
    Let me know if I am unclear thanks!

    Jason

  2. #2
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Quick question regarding line break within code & variable within prompt box

    Disect the following:
    Please Login or Register  to view this content.
    vbNewLine will create a new line in your input box as well as message boxes and wherever you want to start a new line. As for spaces, you have to add them as you go.
    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---

  3. #3
    Registered User
    Join Date
    05-18-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    59

    Re: Quick question regarding line break within code & variable within prompt box

    thankss! 10char

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1