I want to add a buttom to Cell D1 using VBA....

I already have the code to create a button, i just need the code to move the button to the required cell.

ANy help or ideas?

What do you mean by "cell?"


mmcdonal

Look it up at: http://wrox.books24x7.com

It just occurred to me that you were posting about Excel in an Access forum.

To add a button to an Excel worksheet, right click on the top menu, select Controls Toolbar, and then click the button control, and then click the cell. You will have to modify the size of the cell and the button to match each other since the button will just be ON the worksheet, and not IN any cell.

Did that help?


mmcdonal

Look it up at: http://wrox.books24x7.com