VBA Notification pop up

[harryax7]

hello, how i add sound notification in my code please help me

Private Sub Workbook_Open()
Dim r As Range

For Each r In Range("F4:F10")
    If r.Value = Date Then
    
MsgBox ("Hallo Admin "), vbInformation

End If
Next r

End Sub

 

[StephenCrump]

i mean speak our language, not default english

You might need to experiment a little. This is what I just tried ...

My language setting is English. I had only one voice on my computer (Post #9). If I tried Application.Speech.Speak with a French phrase (say), the voice would mangle the pronunciation.

Via my Windows Language Settings, I installed French. I now have two voices, an English and a French. The English voice mangles the French pronunciation. The French voice pronounces the text correctly.

 

[harryax7]

You might need to experiment a little. This is what I just tried ...

My language setting is English. I had only one voice on my computer (Post #9). If I tried Application.Speech.Speak with a French phrase (say), the voice would mangle the pronunciation.

Via my Windows Language Settings, I installed French. I now have two voices, an English and a French. The English voice mangles the French pronunciation. The French voice pronounces the text correctly.

oke dude i'll try later, but now when i run the VBA always show notife eror, i already ceklis in the trust center

 

[harryax7]

oke dude i'll try later, but now when i run the VBA always show notife eror, i already ceklis in the trust centerView attachment 68778

SOLVED, only ceklist, in file properties