Uploaded August 2019 | Updated November 2026, 23 hours ago
How to display specific worksheet data quickly and easily using option buttons with VBA.
Here's the complete VBA code:
Option Explicit
Private Sub OptionButton1_Click()
Application.ScreenUpdating = False
Columns("A:B").Hidden = True
Columns("C:J").Hidden = False
Columns("K:AN").Hidden = True
Range("C6").Select
Application.ScreenUpdating = True
End Sub
Private Sub OptionButton2_Click()
Application.ScreenUpdating = False
Columns("A:L").Hidden = True
Columns("M:T").Hidden = False
Columns("U:AN").Hidden = True
Range("M8").Select
Application.ScreenUpdating = True
End Sub
Private Sub OptionButton3_Click()
Application.ScreenUpdating = False
Columns("A:V").Hidden = True
Columns("W:AD").Hidden = False
Columns("AE:AO").Hidden = True
Range("W8").Select
Application.ScreenUpdating = True
End Sub
Private Sub OptionButton4_Click()
Application.ScreenUpdating = False
Columns("A:AF").Hidden = True
Columns("AG:AO").Hidden = False
Range("AG6").Select
Application.ScreenUpdating = True
End Sub
Private Sub OptionButton5_Click()
Application.ScreenUpdating = False
Columns().Hidden = False
Range("A1").Select
Application.ScreenUpdating = True
End Sub
Take care to use the proper regions to hide and display for your data.
Details also available on our website: exceltrainingvideos.com/display-worksheet-data-quickly-and-easily
How to display specific worksheet data quickly and easily using option buttons with VBA.
Here's the complete VBA code:
Option Explicit
Private Sub OptionButton1_Click()
Application.ScreenUpdating = False
Columns("A:B").Hidden = True
Columns("C:J").Hidden = False
Columns("K:AN").Hidden = True
Range("C6").Select
Application.ScreenUpdating = True
End Sub
Private Sub OptionButton2_Click()
Application.ScreenUpdating = False
Columns("A:L").Hidden = True
Columns("M:T").Hidden = False
Columns("U:AN").Hidden = True
Range("M8").Select
Application.ScreenUpdating = True
End Sub
Private Sub OptionButton3_Click()
Application.ScreenUpdating = False
Columns("A:V").Hidden = True
Columns("W:AD").Hidden = False
Columns("AE:AO").Hidden = True
Range("W8").Select
Application.ScreenUpdating = True
End Sub
Private Sub OptionButton4_Click()
Application.ScreenUpdating = False
Columns("A:AF").Hidden = True
Columns("AG:AO").Hidden = False
Range("AG6").Select
Application.ScreenUpdating = True
End Sub
Private Sub OptionButton5_Click()
Application.ScreenUpdating = False
Columns().Hidden = False
Range("A1").Select
Application.ScreenUpdating = True
End Sub
Take care to use the proper regions to hide and display for your data.
Details also available on our website: exceltrainingvideos.com/display-worksheet-data-quickly-and-easily










