Help cant solve this links on worksheet problem

J

jimmyD

Is ther any way to auto formate the active cell, and once that cell is
no longer active to clear the format of that cell in within a range
say A:A

If not how do i group toggle buttons on a work sheet, say across A:A
that work as a group one only able to be active at a time.

is it possible to group control buttons or form buttons in a simular
way?

Pulling out the hair i need. :'(
 
G

Gary''s Student

This is just a demo of the technique. Put this in worksheet code, not a
standard module:


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Range("B9")
If Intersect(Target, .Cells) Is Nothing Then
.ClearFormats
Else
.Interior.ColorIndex = 6
End If
End With
End Sub

If you select cell B9, its format will have a yellow background. If you
select another cell, the format of B9 will clear.
 
Top