Noobie VBA Question

[mcwilson]

Sorry for the pathetic question, but I would love some help!

I have code to enter into VBA...I hit Alt-F11 and paste the code in. On the top it reads "General" and then "Worksheet Change".....is that correct?

Once the code is in, how do I run it?
If i go to the "Run" tab, the box comes up, but i do not have anything listed in there.....

Any help would be greatly apprecaited.

Thanks

 

[Domski]

Unless your code is specific to a sheet or workbook such as events it should really sit in a regular vba module.

Have a look here for how to add one to your project: http://www.contextures.com/xlvba01.html

Dom

 

[doofusboy]

If your code is in WorksheetChange, making any change [like entering something in a cell] should trigger your code to run.

 

[mcwilson]

i am still struggling....any chance you would want to take a look at this file for me?

 

[Ruddles]

What's the code supposed to do?

1. If it's meant to be triggered by a workbook-level event like the workbook opening or closing, then it belongs in the ThisWorkbook code module, with the Sub name selected from the drop-down.
2. If it's meant to be triggered by a worksheet-level event like a cell being changed or the sheet being recalculated, then it belongs in the code module for that worksheet, with the Sub name selected from the drop-down.
3. If it's meant to be called directly by the user from the Macros menu option, by a button or some other clickable 'thing' on the worksheet, or if it's a 'user-definable Function' (UDF), you would create a new 'general' or 'standard' code module for it by clicking Insert > Module in your VBA editor and pasting the code into that.

Which of those three is is, do you know?

Showing us the code might help us determine this if you don't know, but please paste it in its entirety between CODE tags - the # icons in the advanced editor toolbar.

If you got the code from the Web somewhere, letting us have the URL might also be helpful.