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:
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
Thanks for any help that can be provided - I have found a lot of helpful information on this site already.