Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change cell value by code
I am trying to get the text value in cell D5 to alternate from "show dates"
to "hide dates" depending whether cols A-C (where the dates are) are visible or not using the following: Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) 'right clicking D5 will show/hide columns A-C (date, time and user name)) If Not Application.Intersect(Target, Range("D5")) Is Nothing Then Columns("A:C").EntireColumn.Hidden = Not Columns("A:C").EntireColumn.Hidden ==Target.Value = "hide dates": Target.Value = "show dates"<== this bit pls! Cancel = True End If I'm a bit stuck. Thanks -- Traa Dy Liooar Jock |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allow VBA code to change a locked cell?? | Excel Programming | |||
code to change color of negative cell | Excel Programming | |||
How to Run VBA Code on cell or range change | Excel Programming | |||
How to Run VBA Code on cell or range change | Excel Programming | |||
run code after cell contents change | Excel Programming |