There is a lot of information on this site for beginners. My opinion is that
is about as basic as it gets in explaining VBA programming.

http://www.excel-vba.com/excel-vba-contents.htm

"Zak" wrote:

I have used the control toolbox method aswell. how can i get my macro to work
from sheet 2/3/4? at the moment it only works in the sheet with the data in
it.

thanks.

"JLGWhiz" wrote:

See this site.

http://www.ozgrid.com/News/jan-2006.htm

Unfortunately, you only get one shot to use the assign macro dialog box when
you use the button from the forms toolbar. The button from the Controls
Toolbox allows much more flexibility.

"Zak" wrote:

I have tried many times to add my macro to a button but it does not work. I
have tried both the control toolbox and the forms menu.

I am in design view when i create the button, double click it to show the
VBE, enter the below code, go back to the button coming out of design view
but nothing happens! not even an error. same when i do it via the forms menu,
i assign the button but nothing happens!!
(replace is my macros name.)

Private Sub CommandButton1_Click()
Run "replace"

End Sub

please help. thanks.