+ Reply to Thread
Results 1 to 3 of 3

help - create a multiple choice test

  1. #1
    robynhaga@gmail.com
    Guest

    help - create a multiple choice test

    I want to be able to have the person put an "X" in a cell or check a
    cell and have a numeric value appear in a column to the right of the
    test. Does anyone know if this is possible?


  2. #2
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,186
    if the cell containing the X is A1 and the cell in which you want the value is B1 then the formula in B1 is =if(a1="X", 1,"")

    hope this helps

  3. #3
    Bob Phillips
    Guest

    Re: help - create a multiple choice test

    Private Sub Worksheet_Change(ByVal Target As Range)
    Const WS_RANGE As String = "C5:E5" '<=== change to suit

    On Error GoTo ws_exit:
    Application.EnableEvents = False
    If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
    With Target
    If .Value = "X" Then
    .Offset(0, 1).Value = 1
    Else
    .Offset(0, 1).Value = ""
    End If
    End With
    End If

    ws_exit:
    Application.EnableEvents = True
    End Sub

    'This is worksheet event code, which means that it needs to be
    'placed in the appropriate worksheet code module, not a standard
    'code module. To do this, right-click on the sheet tab, select
    'the View Code option from the menu, and paste the code in.


    --
    HTH

    Bob Phillips

    (replace somewhere in email address with gmail if mailing direct)

    <robynhaga@gmail.com> wrote in message
    news:1153135169.591604.280050@s13g2000cwa.googlegroups.com...
    > I want to be able to have the person put an "X" in a cell or check a
    > cell and have a numeric value appear in a column to the right of the
    > test. Does anyone know if this is possible?
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1