where to write the macro for a button.

[nilsanp]

I want to make a button in my excel sheet, and i write the macro in the microsoft excel objects, Sheet1, where the button is. That doesnt work, but if i write it in Module1, it works.

Why doesnt it work when written in Sheet1. I know this is a very fundamental question which i propably should have been able to find an answer to, but i have now tried, and cant find that information. I'm sorry.

I want several buttons in my "sheet1", and to me it makes sense that i should write the macros for all the buttons which is placed in sheet1, in the corresponding microsoft excel objects.

As you may have figured out, i'm not completely familiar with the different purposes of excel objects and modules.

I have done some VBA coding before, but thats a long time ago now, and i need help to get started.

Thanks

[Andy Pope]

Assume you are using Form controls, rather than ActiveX, and are trying to assign a macro.

Generally the button code would be stored in a standard code module.
But if you want to place the code in the sheet object then you can. You just need to assign the macro to the local routine.

Sheet1.Button2_Click

[nilsanp]

That was it.

Thanks.

I had ! instead of ., and i guess thats another kind of reference.

[jwright650]

Something that Excel does is a help to me.....

ie.Command button on a sheet...while in Design mode, right-click the object(cmdButton) and choose "view code"....you can add the code for the button there.

ie.Active X controls for a UserForm, when you add the controls to the UserForm, you can double-click the control and it will open the editor window so you can add the code for that control.