VBA: drop down list for number of columns?

[jeff.jiexi]

I want to create a drop-down list that allows me to select how many columns are presented in the sheet.

For example, my worksheet is like:
2007 2008 2009 2010
a 100 100 100 100
b 100 100 100 100
d 100 100 100 100

In the drop-down list, if 3 is chosen, then 2008, 2009, and 2010 columns are shown;
if 2 is chosen, only 2009 and 2010 columns are shown;
if 5 is chosen, then a new 2006 column can be added and so forth.

How can I write a macro for this please?
I tried to record a macro; but it doesn't work properly.

Thank you so much for your help!

[salimudheen]

Hi Jeff,

I have created one simple solution for you!!!!

Its very simple to start macro.

Steps what i have did:
1. Added dropdown from insert - dropdown list
2. Bind the values
3. Set the selected value in one cell.
4. Then open the code window (Alt+F11)
5. Insert module then write one small function.

Find the attachment.

I hope it will more useful to U!!!

Have a good stuff!!!

Regards,
Salim

[jeff.jiexi]

Hi Salim,

Thank you so much for your help!
It's great to have this solution!

I'll see if i can make some further use of your function here.

Jeff