How to implement VBA Code

[GoSkins]

I found code on the internet for "Selecting multiple items from a drop down list" in Excel. I have never used VBA, but am proffecient on a computer and in MS Office. How do I implement this code to make it work?

 

[ClulessChris]

Open Excel
Press Alt & F11
Paste in the code
press F8 (this will 'step' the code through line by line each time you press F8, and you can follow the code operation).


be carefull of what code you do this with as if it's malicious, it may cause you some bother.

you may be better off recording a macro and looking at the code it generate first.

good luck.

Never knock on Death's door: ring the bell and run away! Death really hates that!

 

[GoSkins]

Thanks, I've already gotten in to VBA, I'm on Excel '07. I have also already pasted the code into a module and the sheet i want it on. Nothing. I have never used VBA before so I am completely lost. How do I record a macro?

 

[ClulessChris]

Tools > macros > Record macros

Never knock on Death's door: ring the bell and run away! Death really hates that!

 

[CaptainD]

Depending on the code in your module and how you want to "run" it, you might not need a Macro.

There are events that can run code as well. Command buttons have "Click" events as well as others. Forms have "Activate", "Load" etc.

If you post your code so we can see what it does we can offer pointers as to where to run it or how.

 

[fumei]

Yes, we need actual details of what you are doing.

"How do I implement this code to make it work?"

Without knowing exactly what "this code" is...

faq219-2884

Gerry
My paintings and sculpture