|
Subject:
|
Add a button to a cell
|
|
Posted By:
|
hewstone999
|
Post Date:
|
6/3/2008 5:16:16 AM
|
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?
|
|
Reply By:
|
mmcdonal
|
Reply Date:
|
6/4/2008 7:19:50 AM
|
What do you mean by "cell?"
mmcdonal
Look it up at: http://wrox.books24x7.com
|
|
Reply By:
|
mmcdonal
|
Reply Date:
|
6/4/2008 7:23:46 AM
|
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
|
