Member Avatar for Behseini

using MS Excel 2007, and VBA I have two combobox.The first combobox has three items as:{One, Tow, Three} now I would like to load the second combobox based on what user select in combobox1. For example if user select One in the from combobox1 then namebox1 will populate to combox2 and if if user select Two in the from combobox2 then namebox2 will populate to combox2 and so on..

Can you please let me know how I can do this in VBA?

Thanks

Edited by Behseini
  • 2 Contributors
  • 1 Reply
  • 178 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by AndreRet
Member Avatar for AndreRet

You can try the following -

If combo1.Value = "One" Then
    combo2.AddItem "stuff for one"
Elseif combo1.value = "Two" Then
    combo2.AddItem "stuff for two"
        Else
    combo2.AddItem "stuff for three"
End If
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.