add button syntax

[Big Al]

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?

[William]

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
[email protected]


"Big Al" <Big [email protected]> wrote in message
news:[email protected]...
>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?

[Big Al]

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
> [email protected]
>
>
> "Big Al" <Big [email protected]> wrote in message
> news:[email protected]...
> >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?
>
>
>