does anyone know how to place buttons or textboxes on worksheet with vba or manually?
+1
A:
It always helps to know which version of Excel you're working in.
In Excel 2003, right-click any toolbar and enable the Forms toolbar. Select the Button from there. This type of button can be assigned to a macro so that when someone clicks it, the macro is executed.
In Excel 2007, go to the Excel menu and select Excel Options. Select Popular and then check the Show Developer Ribbon option. On the Developer ribbon, select the Insert... pulldown and you'll be able to do basically the same series of steps as above.
HTH, Neb
its about time someone answered this question!!! ive been waiting two days and been reposting it
I__
2009-12-18 00:09:05