View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Valerio Valerio is offline
external usenet poster
 
Posts: 2
Default How to create a form control over a specific cell

"Valerio" ha scritto nel messaggio
...
I'm trying to automatically create form controls such as check boxes and

put
them on a work sheet.


Ok, I found the answer by myself... I'm posting it here if someone else need
it.

Set c = ws.Range("c32")
Set cb = ws.Shapes.AddFormControl(xlCheckBox, c.left, c.top,
c.Width,c.Height)

The properties left / top etc. are what I needed.

Thank you