Results 1 to 4 of 4

Thread: attatchment

  1. #1
    Join Date
    Dec 2003
    Posts
    6

    Unanswered: attatchment

    ive attathed the file. the the probs are with the bits under the 'targets met?' section
    Attached Files Attached Files

  2. #2
    Join Date
    Sep 2003
    Location
    Cincinnati, Oh USA
    Posts
    203

    Re: attachment

    Can you be more spefic? I've downloaded your XL file and need for info (do you want the option buttons to respond as true/false or ?)
    Originally posted by Priyam87
    ive attathed the file. the the probs are with the bits under the 'targets met?' section
    Last edited by RickKnight; 12-23-03 at 19:55.
    Rick Knight
    KnightShift Office Solutions and Horse Breaking
    VB, VBA, FileMaker, Access Solutions, Web Solutions

  3. #3
    Join Date
    Dec 2003
    Posts
    6
    hi,
    i need it 2 reply as yes or no. i think i need an IF formula to go with the 1 and 2 as the original prob is sorted

  4. #4
    Join Date
    Sep 2003
    Location
    Cincinnati, Oh USA
    Posts
    203
    See the attached sample. Note that I've placed VBA Yes/No option buttons into a Group Box to isolate them and prevent them from reacting with any other option buttons on the sheet. Then in VBA code in sheet 1 I've used this code:

    Private Sub optNo1_Click()
    Dim n
    n = "No"
    If optNo1.Value = True Then
    Sheet1.Cells(4, 5) = n
    End If
    End Sub

    Private Sub optYes1_Click()
    Dim y
    y = "Yes"
    If optYes1.Value = True Then
    Sheet1.Cells(4, 5) = y
    End If

    End Sub

    Replicate this for your second set of option buttons and your there


    Merry Christmas
    Originally posted by Priyam87
    hi,
    i need it 2 reply as yes or no. i think i need an IF formula to go with the 1 and 2 as the original prob is sorted
    Attached Files Attached Files
    Last edited by RickKnight; 12-25-03 at 10:23.
    Rick Knight
    KnightShift Office Solutions and Horse Breaking
    VB, VBA, FileMaker, Access Solutions, Web Solutions

Posting Permissions

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