How to Select Worksheet and Cell/range based on ComboBox Values

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.

Welcome to the world of VBA. To start, you don't usually need to activate or select a sheet or range. You can generally apply the code directly, which is faster. It is not 100% clear to me what your question is so I will give you some code that will hopefully push you in the right direction:

Please Login or Register  to view this content.

Thanks for your help. The goal is, through a userform, the user been able to create an empty table (with just the column titles) composed by given categories, given subcategories and items/subsubcategories to be defined, all of them linked together (sort of questionnaire). Then the table is going to be filled with specific time-dependent information of the user. The idea was too general (too much flexibility) so to be implemented. I will rethink the way of doing it. Once again thanks. Best regards.