Results 1 to 9 of 9

Resizing A Message Box

Threaded View

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

    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!

    Public Sub Unhide2()
    
    
    CarryOn = MsgBox("--- FIRST TIME USE ONLY ---, CONTINUING WILL ERASE ALL PREVIOUS DATA ENTERED! --- Do you wish to continue?", vbYesNo)
    If CarryOn = vbYes Then
    'put rest of code here
    
        Application.ScreenUpdating = False
    
    Set PreviousSheet = ActiveSheet
    
    With Worksheets("Set-Up")
        .Visible = True
        .Select
        .Range("A1").Select
    End With
    Application.ScreenUpdating = True
    End If
    End Sub
    Last edited by Tubtech; 12-19-2021 at 03:13 PM.

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. 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