Using the MsgBox function, you can have the following Buttons:
vbOKOnly 0 Display OK button only.
vbOKCancel 1 Display OK and Cancel buttons.
vbAbortRetryIgnore 2 Display Abort, Retry, and Ignore buttons.
vbYesNoCancel 3 Display Yes, No, and Cancel buttons.
vbYesNo 4 Display Yes and No buttons.
vbRetryCancel 5 Display Retry and Cancel buttons
Using a UserForm you can have whatever Buttons you want.
The message box method does not allow many choices. I would handle something like this :-
rsp = MsgBox("Is this an Electrical (or Plumbing) Wholesaler ?" & vbCr _
& "'Yes' for Electrical" & vbCr _
& "'No' for Plumbing", vbYesNoCancel)
If rsp = vbYes Then
' "yes" code here
ElseIf rsp = vbNo Then
' "no" code here