Scribd
Upload
12 views4 pages

Excel VBA Toggle Button Guide

This document contains a table with columns for description, reference number, and days for different roles (R0, R1, R2, R3) along with remarks. All cells are empty except for the date in cell F43677 and the toggle button code hides or shows columns F and G.

Uploaded by

Anish Mangalathu Mohanan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
12 views4 pages

Excel VBA Toggle Button Guide

This document contains a table with columns for description, reference number, and days for different roles (R0, R1, R2, R3) along with remarks. All cells are empty except for the date in cell F43677 and the toggle button code hides or shows columns F and G.

Uploaded by

Anish Mangalathu Mohanan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Hide Days Hide Comments

Type of
Sl no Description Ref: no R0 Days R1 Days
Doc
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
R2 Days R3 Days R0 Days Remarks R1 Days R2

0 0
0 0
0 0
0 0
0 0
31-Jul-19 43677 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
Days R3 Days

0 0
Private Sub ToggleButton1_Click()
Dim xAddress As String
xAddress = "F:G"
If [Link] Then
[Link](xAddress).Hidden = True
[Link] = "Show Column"
Else
[Link](xAddress).Hidden = False
[Link] = "Hide Column"
End If
End Sub

You might also like