I have combobox list with product options:
Z1
Z2
Z3 etc.
and I want to to repeat the same macro (copy and paste range) every time when sb choose product from the list.
Attached you will find a .xls with the recorded macro I don't know how to relate the functioning of the macro from the choosing of the value from Combobox
I know that I should use Select Case but I don't know how.
Thank you for your help in advance.
Here is the recorded macro:
Expand|Select|Wrap|Line Numbers
- Sub PROD_Z()
- '
- ' PROD_Z Macro
- '
- '
- Columns("I:L").Select
- Range("I2").Activate
- Selection.Copy
- Columns("N:N").Select
- Range("N2").Activate
- ActiveSheet.Paste
- Range("Q1").Select
- Application.CutCopyMode = False
- ActiveCell.FormulaR1C1 = "Z2"
- Range("Q3:Q18").Select
- Selection.ClearContents
- End Sub