VBA Message Box in Excel‼️ | Excel Learning #exceltips #excel #shorts #vba

VBA Message Box in Excel‼️ | Excel Learning #exceltips #excel #shorts #vba

In this video, you will learn how to create message box in Excel.

VBA Code :

Sub ChangeTextColorAndFontStyle()
Dim answer As Integer
Dim cell As Range

' Display the popup asking if you want to change the color
answer = MsgBox("Do you want to change the Colour?", vbYesNo + vbQuestion, "Change Colour")

' If the user selects 'Yes', change the color and make the font bold
If answer = vbYes Then
' Loop through all cells in Column A (Row A refers to cells in Column A)
For Each cell In Range("A1:A" & Cells(Rows.Count, "A").End(xlUp).Row)
cell.Font.Color = RGB(0, 0, 255) ' Blue color
cell.Font.Bold = True ' Make the font bold
Next cell
End If
End Sub

#exceltech #exceltips #exceltutorial #excel #exceltricks #excelhacks #excelformulas #excelfunctions #excelseries #day1excel #excellearn #learnexcel #excelforbeginners #microsoftexcel #msexcel #shortvideo #shorts #excelshorts #excelcourse #dataanalysis #analytics #dataanalyticscourse #vba #message #box