Results 1 to 10 of 10

Validation list to change columns values

Threaded View

  1. #1
    Registered User
    Join Date
    03-24-2009
    Location
    In my own little world
    MS-Off Ver
    Excel 2007
    Posts
    5

    Validation list to change columns values

    So I've got a drop down list in cell B73 That when I change the selection I want it to copy the cells below it (B74:B94) from one of the charts above it. Through the power of Google I found this: http://www.eggheadcafe.com/conversat...eadid=29484871, someone who had the same need as me, and edited it accordingly to my needs. It however, is not working. I started with Case 1-7 and changed them thinking they need to be the same as the list but that hasn't fixed it either. File is attached, and below quote is what the VBA coding currently says.

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Not Application.Intersect(Range("B73"), Target) Is Nothing Then
    Select Case Target.Value
    Case Human: Range("B74:B94").Value = Range("B2:B22").Value
    Case Elf: Range("B74:B94").Value = Range("C2:C22").Value
    Case Drow: Range("B74:B94").Value = Range("D2:D22").Value
    Case Dwarf: Range("B74:B94").Value = Range("E2:E22").Value
    Case Orc: Range("B74:B94").Value = Range("F2:F22").Value
    Case Centaur: Range("B74:B94").Value = Range("G2:G22").Value
    Case Gnome: Range("B74:B94").Value = Range("H2:H22").Value
    End Select
    End If
    End Sub
    Attached Files Attached Files
    Last edited by avisamo; 03-26-2009 at 07:21 AM. Reason: solved

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