Insert object - What do the numbers between ( ) do or mean?

[Event2020]

This is related to a different question I asked about getting exact position on a sheet of a option box but I have made it a separate question in case it can be applied to other objects and therefore perhaps help others.

Admin please delete if you feel this question is not appropriate.

I have a macro that creates a option box on a worksheet and I have noticed that there is a range of numbers placed inbetween brackets.

ActiveSheet.OptionButtons.Add(131.25, 558.75, 38.25, 17.25).Select

Does anyone know what the numbers mean or do?

If i remove them so it looks like this

ActiveSheet.OptionButtons.Add().Select

then run the macro it produces the VBA error argument not optional so the numbers must be doing something?

 

[Leith Ross]

Hello Event2020,

They are the position arguments: Left, Top, Width, and Height. These control the placement of the object on the worksheet using the upper left corner as the start position.

 

[Event2020]

Hello Event2020,

They are the position arguments: Left, Top, Width, and Height. These control the placement of the object on the worksheet using the upper left corner as the start position.

Hi Leith

Thats brilliant, I was hoping that was what they were.

Thanks a lot

 

[Leith Ross]

Hello Event202,

You're welcome. Glad I could shed some light on the mystery numbers.