View Full Version : [SOLVED:] Set Focus To A Particular Cells with OptionButton
Ladyj205
06-08-2018, 06:16 AM
I have 5 sets of yes and no optionbuttons (active x controls). "No" is set for default.
I want to achieve on when the OptionButton "Yes" is clicked it would automatically take take focus on that cell.
Private Sub OptionButton1_Click()
If OptionButton1 = "Yes" Then
Range("A1").Select
Else
Range("B1").Select 'Default Range
End If
End Sub
Ladyj205
06-08-2018, 11:48 AM
Private Sub OptionButton1_Click()
If OptionButton1 = "Yes" Then
Range("A1").Select
Else
Range("B1").Select 'Default Range
End If
End Sub
works like a charm!!
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.