+ Reply to Thread
Results 1 to 9 of 9

Resizing A Message Box

  1. #1
    Forum Contributor
    Join Date
    11-30-2020
    Location
    Ny
    MS-Off Ver
    Office 365
    Posts
    173

    Resizing A Message Box

    Im using this code for an option to run a macro or not, it works just fine, is there a way to resize the box so the message is on one line straight across and not wrapped? Thanks!

    Please Login or Register  to view this content.
    Last edited by Tubtech; 12-19-2021 at 03:13 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Resizing A Message Box

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Resizing A Message Box

    Removed pending moderator request.

  4. #4
    Forum Contributor
    Join Date
    11-30-2020
    Location
    Ny
    MS-Off Ver
    Office 365
    Posts
    173

    Re: Resizing A Message Box

    ok, updated.

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Resizing A Message Box

    I believe it's possible, but highly complex & not worth the effort. Why not put the message on 3 lines like
    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    11-30-2020
    Location
    Ny
    MS-Off Ver
    Office 365
    Posts
    173

    Re: Resizing A Message Box

    Thanks ! its not a big issue but i'll give your suggestion a try!!

  7. #7
    Forum Contributor
    Join Date
    11-30-2020
    Location
    Ny
    MS-Off Ver
    Office 365
    Posts
    173

    Re: Resizing A Message Box

    perfect ! and it looks so much better ! Thanks again!

  8. #8
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Resizing A Message Box

    Glad to help & thanks for the feedback.

  9. #9
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Resizing A Message Box

    I think Fluff's solution is better than a solution that puts everything on one line, but you can do it by creating your own UserForm with whatever dimensions you need. I won't provide details since this seems to be solved.

+ 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] Command Button Text Resizing, or Command Button Resizing
    By hk57 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-20-2020, 05:29 AM
  2. Resizing Rows if Value is there
    By Cremorneguy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2014, 12:00 PM
  3. Resizing comments
    By adamjohnson182 in forum Excel General
    Replies: 6
    Last Post: 06-08-2012, 03:10 PM
  4. Resizing rows
    By balper in forum Excel General
    Replies: 7
    Last Post: 10-29-2010, 05:05 AM
  5. Resizing cells in a selection without resizing entire sheet
    By Danielle via OfficeKB.com in forum Excel General
    Replies: 4
    Last Post: 08-11-2006, 05:10 PM
  6. [SOLVED] cell resizing
    By DZ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2006, 07:45 AM
  7. Resizing Picture
    By SamDev in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-14-2005, 11:05 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