autofit msgbox to text length
my msgbox is too short and a line of text moves to two lines.
- I want the line of text to be on one line.
- All text is showing in the msgbox, just not on one line
- the text length could change randomly
Is there an option to 'autofit' the msgbox
Code:
Dim answer As Integer
Dim PullFromPPTFileName As String
PullFromPPTFileName = "Figure 121. Gonorrhea - Rates by Year, Tucson Total, 2017-2021.pptx"
answer = MsgBox("The current file to be uploaded is" _
& vbCrLf & _
PullFromPPTFileName _
& vbCrLf _
& vbCrLf & _
"Would you like to upload the correct file and try again?", _
vbQuestion + _
vbYesNo + _
vbDefaultButton1)
If answer = vbYes
Then MsgBox "Yes"
Else MsgBox "No"
End If
