MrExcel.com - Your One Stop for Excel Tips & Solutions

Macro to VB

Posted by Anthony on June 18, 2001 12:15 PM

Hello to all! I'm looking to assign buttons to perform commands on my worksheet. I'm referring more towards buttons from the control toolbox and not graphic art or hot-spots. Anyway, I've attempted to do this by creating a marcro then copying that code to the button of my choice. Is that possible? Each time I do this, I receive variuos "run time" error messages. What am I missing? Any advice would be greatly appreciated.

Thanks

Anthony

Posted by Russell on June 18, 2001 12:24 PM

When you copy your stuff, don't copy the first or last lines (so Sub DoThis would be the first, and End Sub would be the last). Otherwise it should work.