VBE msgbox

[mbrandt7279]

I have a user form with 125 checkboxes and if checked would like them to display one message box containing a specific message for that the checkbox slection, but all messages in one message box.

I have one command button that will list each message box individually, using code like this -
If CheckBox12 = True And CheckBox5 = True Then MsgBox "You would need to see your manager"

Each message box individually is time consuming and it would be better if they all displayed in one box. Of the 125 check box options, 7 or 8 will only be selected at any given time.

Any help would be greatly appreciated, and thank you for your patience I have only been coding in VBE fo a week.

Thank you,

 

[AlphaFrog]

Hi and welcome to the forum.
Maybe try something like this...

    [color=green]'Build a message string then display the one built up message in a message box[/color]
    [color=darkblue]Dim[/color] strMsg [color=darkblue]As[/color] [color=darkblue]String[/color]
    
    [color=darkblue]If[/color] CheckBox12 And CheckBox5 [color=darkblue]Then[/color] strMsg = strMsg & "You would need to see your manager" & vbLf & vbLf
    
    [color=darkblue]If[/color] CheckBox13 And CheckBox6 [color=darkblue]Then[/color] strMsg = strMsg & "You would need to do something else" & vbLf & vbLf
    
    [color=green]'[/color]
    [color=green]'[/color]
    [color=green]'[/color]
    
    [color=green]'Display one message box[/color]
    [color=darkblue]If[/color] Len(strMsg) > 0 [color=darkblue]Then[/color] MsgBox strMsg

 

[mbrandt7279]

Thank you so much that works great. I really appreciate it. WOW that is so much better.

 

[AlphaFrog]

You're welcome.

 

[Garry2Rs]

I'm trying to imagine how your userform displays, having 125 checkbox controls on it! Is there any way you can export the userform to a file that you can upload/attach so we can have a look? I can't help thinking there's a better approach than using 125 checkbox controls! I agree with AlphaFrog's suggestion to implement a StringBuilder methodology, but I'm not sold on using MsgBox.

I'm thinking a multi-select listbox (check style) with the messages displayed in a single adjacent scrollable control.