Results 1 to 3 of 3

Modifying MsgBox text?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Modifying MsgBox text?

    I have this code,
    Sub DropSetCalc()
    '
      MsgBox ("Minimum Stress- " & Range("k31").Text)      
               
    End Sub
    What I would like to do is add the text "Maximum Stress- " and the range K32 and have this second line of text appear under the first line when the message box pops up. How would the code get modified so the text appears directly under the first line of text, instead of one long line?
    Last edited by Butcher1; 04-02-2015 at 11:10 AM. Reason: Added missing CODE tags.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Align msgbox text and Bold & underline certain text
    By alexnkc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2013, 11:01 PM
  2. Modifying XML Excel functions in a Text File
    By christuna in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-21-2011, 08:09 PM
  3. Modifying a text value
    By rucypher in forum Excel General
    Replies: 2
    Last Post: 08-09-2010, 11:38 AM
  4. Replies: 1
    Last Post: 05-02-2007, 06:30 PM
  5. Modifying Drop-Down Text in an ActiveX Combo Box
    By akexcel in forum Excel General
    Replies: 3
    Last Post: 10-23-2006, 01:13 PM

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