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
|