Dear Fellows
I'm a beginner in VBA Excel and I am required to do something a bit advance for me. I need to select a worksheet and a cell based on the values of two comboboxes included in a userform. The idea is to create a empty table from the userform and what I believe the code structure should be is the following:
Lets say ComboBox1.List = Array("A","B") and ComboBox2.List = Array ("C", "D")
If ComboBox1.Value = "A" Then
ActiveWorkbook.Sheets("Sheet1").Activate ' Select worksheet 1
If ComboBox2.Value = "C" Then
ActiveSheet.Range("INCTITLES").Select ' Choose a cell in a specific range (e.g., Names of Variables) that has the value of ComboBox2
... ' Other orders (e.g., add column to the right)
Else..
End If
Else...
ActiveWorkbook.Sheets("Sheet2").Activate ' Select worksheet 2
End If
If you could give some hints on how to do this, or any help, it is very, very much apreciate it. Thanks in advance.
Bookmarks