Hi,
I currently doing a project using excel and facing a problem having the form combo box list selection item to hide the sheet column which I need. I found a few thread in this forum but I just can't get it work (run) despite following the code and of course change it to my value.
Basically, I have a list of product for selection and most product have the same column require to be hidden.
Some product require to hide more than 8 different column example: ("A:B:C:D:K:L:M:N:O")
I have created a validation drop down list in cell "B4" and also created a form combobox to link the product list and cell link ("B4") to it. Now, I just need to write a correct code in the combo box assign marco to get it run.
Can anyone help? Many Thanks In Advance
I currently doing a project using excel and facing a problem having the form combo box list selection item to hide the sheet column which I need. I found a few thread in this forum but I just can't get it work (run) despite following the code and of course change it to my value.
Basically, I have a list of product for selection and most product have the same column require to be hidden.
Some product require to hide more than 8 different column example: ("A:B:C:D:K:L:M:N:O")
I have created a validation drop down list in cell "B4" and also created a form combobox to link the product list and cell link ("B4") to it. Now, I just need to write a correct code in the combo box assign marco to get it run.
Can anyone help? Many Thanks In Advance