PDA

View Full Version : Radio Button Not Working



asheesh3337
10-09-2015, 07:39 PM
Thanks to the Forum for helping is at every moment. Great to have friends having helping nature.

I have a sheet in which there are 4 Radio buttons. I want to have the "Freq" value in A2 cell kindly help. Code is

'Radio Button = Mode Of Pmt =
Dim Freq As String
If Me.OBY.Value = True Then
Freq = "Y"
ElseIf Me.OBH.Value = True Then
Freq = "H"
ElseIf Me.OBQ.Value = True Then
Freq = "Q"
ElseIf Me.OBM.Value = True Then
Freq = "M"
Else

End If

Cells(enmptyRow, 1).Value = Freq <==== not working

GTO
10-10-2015, 12:13 AM
'enmptyRow' is misspelt.

asheesh3337
10-10-2015, 01:25 AM
Thanks buddy, such a silly mistake by me

JKwan
10-10-2015, 05:18 AM
To eliminate typo errors, you should use at the very top of each module. I learned the hard way myself....

Option Explicit

SamT
10-10-2015, 08:29 AM
VBA Menu >> Tools >> Options >> Editor Tab>> Require Variable Declaration will put Option Explicit on all new Code Pages.

I check all boxes in the Code Settings Frame