Bonjour ami,
Je crois qu'en ajoutant la partie du bas tu devrais trouver ton compte.
Private Sub Workbook_Open()
Dim Cell As Range
Dim Ws As Worksheet
Set Ws = Worksheets("basededonnéespatient")
For Each Cell In Ws.Range("b2:b" & Ws.Range("b2").End(xlDown).Row)
DateAnniversaire = CDate(Day(Ws.Cells(Cell.Row, "i")) & "/" & Month(Ws.Cells(Cell.Row, "i")) & "/" & Year(Date))
If DateAnniversaire = Date Then MsgBox "Anniversaire De : " & Cell & vbLf & DateDiff("yyyy", Ws.Cells(Cell.Row, "i"), Date) & " ans"
Next
'cette partie-ci
Dim c As Range
For Each c In [BaseDeDonnéesPatient!B2:C49]
c = UCase(c)
Next c
End Sub