V
Valerio
I'm trying to automatically create form controls such as check boxes and put
them on a work sheet.
The function that has to be called appear to be
ActiveWorksheet.Shapes.AddFormControl(xlCheckBox,Left,Top,Width,Height)
I'd like it to be placed over a specific cell but AddFormControl requires
coordinates in pixels. Is there any way to get the pixel coordinates of a
cell? Do you know any other way to accomplish this task?
Thank you.
them on a work sheet.
The function that has to be called appear to be
ActiveWorksheet.Shapes.AddFormControl(xlCheckBox,Left,Top,Width,Height)
I'd like it to be placed over a specific cell but AddFormControl requires
coordinates in pixels. Is there any way to get the pixel coordinates of a
cell? Do you know any other way to accomplish this task?
Thank you.