| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
make button - assign to cell
Is it possible to programatically make a button and assign its location to a
specific cell or cells? -- Thanks, DL |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
make button - assign to cell
hi,
-----Original Message----- Is it possible to programatically make a button and assign its location to a specific cell or cells? -- Thanks, DL . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
make button - assign to cell
slip of the key on the last one, sorry.
To add a button to a sheet programmatically you can use Set btn = ActiveChart.Shapes.AddFormControl _ (xlButtonControl, 35, 10, 30, 15) where the numbers are position left, position top, width and height. To locate it on a particular cell you'll need to set these parameters to the right values. jacob -----Original Message----- Is it possible to programatically make a button and assign its location to a specific cell or cells? -- Thanks, DL . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
make button - assign to cell
Thanks for your help.
"jacob" wrote in message ... slip of the key on the last one, sorry. To add a button to a sheet programmatically you can use Set btn = ActiveChart.Shapes.AddFormControl _ (xlButtonControl, 35, 10, 30, 15) where the numbers are position left, position top, width and height. To locate it on a particular cell you'll need to set these parameters to the right values. jacob -----Original Message----- Is it possible to programatically make a button and assign its location to a specific cell or cells? -- Thanks, DL . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make a cell into a button | Excel Discussion (Misc queries) | |||
| How can I assign a symbol to a button (like the $ button) | Excel Discussion (Misc queries) | |||
| How do I Assign Macro to a button? | Charts and Charting in Excel | |||
| Assign auto_open to a button | Excel Discussion (Misc queries) | |||
| Make a cell into a Macro button | Excel Programming | |||
Linear Mode
