Dynamically/Automatically written code

[cgi_pro]

I have a button called (MyButton) and I want when I click on it then it creates a combo box for me that has three items: "Item1","Item2", and "Item3" and to have the name of this combo box to be (MyList).

Also, in the event of selecting any of this combo box items, then that item text gets printed in cell (A1). I want this code for the MyList_OnChange() subroutine to be automatically created for me when I click on the (MyButton).

Wizards.. please help

[dominicb]

Good afternoon cgi_pro

Does my response in this thread help:

http://www.excelforum.com/showthread.php?t=579984

I'm not 100% clear about what you want to do.

HTH

DominicB

[cgi_pro]

Your answer is almost around what I want, however, whenever I put the code:

Please Login or Register  to view this content.

it gives me this error (check attachment please)

[dominicb]

Hi cgi_pro

Works OK for me - I'm using Excel 2003, what version are you using?

It might be your references want setting. From the VBE go to Tools > References and in the dialog box find and check something that looks along the lines of :
Micrrosoft Visual Basic for Applications Extensibility ...

May vary slightly according to your version of Excel and click OK.

HTH

DominicB

EDIT : If that doesn't work, and you're using XL2002 upwards go to Tools > Macro > Security, Trusted Publishers and check the Trust Access to Visual Basic Project. Let me know.

[cgi_pro]

Thanks a million dominicb

the 2nd way made it work for me