Consulting

Results 1 to 5 of 5

Thread: Radio Button Not Working

  1. #1

    Radio Button Not Working

    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
    Attached Files Attached Files

  2. #2
    Knowledge Base Approver VBAX Guru GTO's Avatar
    Joined
    Sep 2008
    Posts
    3,368
    Location
    'enmptyRow' is misspelt.

  3. #3
    Thanks buddy, such a silly mistake by me

  4. #4
    VBAX Expert
    Joined
    Aug 2004
    Posts
    810
    Location
    To eliminate typo errors, you should use at the very top of each module. I learned the hard way myself....
    Option Explicit

  5. #5
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    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
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •