Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Aug 2012
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exclamation MS Word VBA - Cascading Combo Boxes Help!

    Hi All

    Please could someone tell me how to programme cascading combo boxes using a word userform (VBA)

    I have 3 combos (Post Grade, Question Type, Question)

    So basically if you choose 'G' from the Post Grade combo box, Question Type combo box will be populated with things such as 'ICT Skills', 'Management' etc. Then if you chose 'ICT Skills' from the Question Type combo box, Question combo box will populate with things such as 'What Excel functions can you use?'

    I can already push the choices into the template but cant do the above...

    Thanks

    P.S. This post was close but I cant find the attachment...
    http://windowssecrets.com/forums/sho...VBA-Word-2000)

  2. #2
    New Lounger
    Join Date
    Aug 2012
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    This does what I want (yay) BUT I dont know how to make the items unique....because if you delete 'hello' and re-add it..it adds the same 2 items again!!

    Private Sub cmbQ1QuestionType_Change()
    Select Case cmbQ1QuestionType
    Case "Hello"
    With cmbQ1Question
    .AddItem "Goodbye"
    .AddItem "See ya"
    End With
    End Select
    End Sub

  3. #3
    New Lounger
    Join Date
    Aug 2012
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Worked it out myself...

Tags for this Thread

Posting Permissions

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