Display code in a special window in MrExcel Forum

[Doflamingo]

Hi all,

I know many of you use a specific window when you put the VBA code you use in that forum.

I would like to know how you do it .

Many thanks for your answer

Regards

 

[Joe4]

See: https://www.mrexcel.com/forum/board-announcements/515787-how-post-your-vba-code.html

 

[alansidman]

Highlight your code and then click on the # sign in the menu. These are called code tags.

 

[Doflamingo]

Private Sub CommandButton1_Click()


Dim emptyRow As Long


If TextBox1.Value = "" Or TextBox2.Value = "" Or TextBox3.Value = "" Or ListBox1.Value = "" Or ComboBox1.Value = "" Then
        MsgBox "Formulaire incomplet"
Else
        'Instructions pour insérer le contact ici ...
End If
TextBox1.ForeColor = RGB(0, 0, 0)
TextBox2.ForeColor = RGB(0, 0, 0)
TextBox3.ForeColor = RGB(0, 0, 0)
ListBox1.ForeColor = RGB(0, 0, 0)
ComboBox1.ForeColor = RGB(0, 0, 0)

 

[Doflamingo]

Perfect @alansidman , it works !! Thank you


Kind regards

 

[Joe4]

Perfect @alansidman , it works !! Thank you

That is what the link I posted tells/shows you how to do (along with a few other options!)