Hi,
Please see the attached file. I want the radio buttons unselected (like row 15) when it gets open. Could you please help me?
Hi,
Please see the attached file. I want the radio buttons unselected (like row 15) when it gets open. Could you please help me?
You can set the entire range to 0.
Call it in the worksheet_open event.
You may think about having a error checker, if you select more than one cell in the range you could get an overflow error. Just make it so you get kicked out of the selection_change event if you select more than on cell in that range.Sub SetToZero() Range("D13:H23") = 0 End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Not Intersect(Target, [D13:H23]) Is Nothing Then Application.ScreenUpdating = False
Thank you so much. It is perfect.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks