Excel VBA Macro: Auto-Run Macro When Opening Worksheet (Switching Between Tabs)

Excel VBA Macro: Auto-Run Macro When Opening Worksheet (Switching Between Tabs)
💥Subscribe: / @greggowaffles
Code:
Private Sub worksheet_activate()
MsgBox "hello, world!"
End Sub
#excelmacro #excelvba

[@nixnews2267]

Hi Greg, Could u pls make a macro for sorting excel data? When we select a range and run macro, it should ask which column to sort..the heading of that range. Please...

[@greggowaffles]

Sure! I can do that. So you want it to ask the user to provide the header name and the macro will sort that column? You want it sorted ascending, descending, or both?

[@nixnews2267]

@@greggowaffles assume we have a range, having 6-7 columns. When we run it, it should give us headers of those columns to select for sorting. Select and run it, as u said if u can add ascending/descending then well and good. And thanks to you. Whatever u make, is useful for us.