View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
tegger tegger is offline
external usenet poster
 
Posts: 16
Default 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



.