Display Worksheet Data Quickly and Easily @Exceltrainingvideos
Display Worksheet Data Quickly and Easily  @Exceltrainingvideos
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
Display Worksheet Data Quickly and EasilySort Data in Worksheet As We Type AutomaticallyRun Macro when Result of Formula ChangesAutomate Language Translations Using Excel VBAAutomating Analysis of CSV Files with ADO SQLYouTube Shorts Open Any File Using VBA in ExcelExtract Specific Data from MS Word into Excel with VBATREND Function in ExcelConvert Excel Charts to Images Automatically2021 | Recover Data From Protected Excel File| | Using Google SheetsCreate Data Entry Forms under 10 seconds No VBACopy Paste PDF Data into Excel
Dinesh Kumar Takyar |

Display Worksheet Data Quickly and Easily

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER