add button syntax
 

I need to know the meaning of positional parameters for adding a button.

ActiveSheet.Buttons.Add(400, 40, 10, 10).Select

In the above example, what does the 1st, 2nd, 3rd, and 4th parameters
(within the parenthesis) control?

add button syntax
 

Hi Al

Parameter 1 : How far button starts from left hand side of worksheet (Column
A)
Parameter 2 : How far button starts from top of worksheet (Row 1)
Parameter 3 : Button width
Parameter 4 : Button height
--

XL2003
Regards

William



"Big Al" <Big wrote in message
...
I need to know the meaning of positional parameters for adding a button.

ActiveSheet.Buttons.Add(400, 40, 10, 10).Select

In the above example, what does the 1st, 2nd, 3rd, and 4th parameters
(within the parenthesis) control?

add button syntax
 

William, thanx; that's exactly what I was looking for.

"William" wrote:

Hi Al

Parameter 1 : How far button starts from left hand side of worksheet (Column
A)
Parameter 2 : How far button starts from top of worksheet (Row 1)
Parameter 3 : Button width
Parameter 4 : Button height
--

XL2003
Regards

William



"Big Al" <Big wrote in message
...
I need to know the meaning of positional parameters for adding a button.

ActiveSheet.Buttons.Add(400, 40, 10, 10).Select

In the above example, what does the 1st, 2nd, 3rd, and 4th parameters
(within the parenthesis) control?