help with vba code for an interface

[aiman015]

hello guys,
actually i am trying to make an interface for my workbook, and i started making it using vba, but i got stuck.
FIRST: in "what do you want to do" section i want to print two possibilities : consumption and KPI.
then if the user choose consumption,
-->the second part "what kind of energy"print 3 possibilities (electricity,water,gaz)
if else the user choose KPI,
--> "what kind of energy" print 3 other possibilities (KPI1,KPI2,KPI3)
Finally: each choice needs to be related to a worksheet, and send the user directly to that sheet named electricity or KPI1...etc by using the button "validate".
the problem is i tried so many codes, but it didn't work.
thanks a lot

 

[Yongle]

With 2 ComboBoxes ..
Combobox1 (What do you want to do?)
Combobox2 (What Kind of Energy?)
And 2 command buttons ..
CommandButton1 (Validate)
CommandButton2 (Reset)

Private Sub UserForm_Initialize()
    ComboBox1.SetFocus
End Sub
Private Sub ComboBox1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
    ComboBox1.List = Array("Consumption", "KPI")
    ComboBox1.DropDown
End Sub
Private Sub ComboBox1_Change()
    ComboBox2.SetFocus
End Sub
Private Sub ComboBox2_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
    Select Case ComboBox1.Text
        Case vbNullString
            ComboBox1.SetFocus
        Case "Consumption"
            ComboBox2.List = Array("Electricity", "Water", "Gaz")
            ComboBox2.DropDown
        Case "KPI"
            ComboBox2.List = Array("KPI1", "KPI2", "KPI3")
            ComboBox2.DropDown
    End Select
End Sub
Private Sub CommandButton1_Click()
'Validate Button code
   Sheets(ComboBox2.Text).Activate
   Unload Me
End Sub
Private Sub CommandButton2_Click()
'Reset Button code
    ComboBox1.Value = ""
    ComboBox2.Value = ""
End Sub

 

[Fluff]

Cross posted vba code for an interface

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.