Hello All!,
I am trying to input a userform msgbox because i would like the ability to format the text to my like in the msgbox. Now my question is, in my current msgbox code, which is pasted below, i have some formulas being input into the message. How would i be able to implement those into the userform.
I am fairly new with userforms, just discovered them recently and i think they are amazing!
Thank you for all your help!
I am trying to input a userform msgbox because i would like the ability to format the text to my like in the msgbox. Now my question is, in my current msgbox code, which is pasted below, i have some formulas being input into the message. How would i be able to implement those into the userform.
I am fairly new with userforms, just discovered them recently and i think they are amazing!
Thank you for all your help!
Code:
Sheets("RL").Select
RLCounter = Application.WorksheetFunction.CountIfs(Range("P:P"), 1, Range("N:N"), "**Did Not Apply")
Sheets("MA").Select
MACounter = Application.WorksheetFunction.CountIf(Range("N:N"), 0)
MsgBox "Maria, there are " & RLCounter & " unapplied transactions!" + vbNewLine + vbNewLine & "Also there are " & MACounter & " incorrectly applied!"