New user - hope this works out:
I'm trying to use option buttons to create a text entry in an adjacent cell.
Selecting Option Button 1 puts "GPM" in cell F23
Selecting Option Button 1 puts "lbm/hr" in cell F23
(The option buttons are from the control toolbox)
I receive ""Run-time error '424': Object Required"" and first line is highlighted- here is copy of code:
Code
Sub FlowUnits()
If OptionButton1.Value = True Then
Sheets("Main Screen").Range("F23") = "GPM"
End If
If OptionButton2.Value = True Then
Sheets("Main Screen").Range("F23") = "lbm/hr"
End If
'
End Sub
Display More
Thanks for any help that can be provided - I have found a lot of helpful information on this site already.