| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a Graphic on a Button when the Button is Assigned to a M | Excel Discussion (Misc queries) | |||
| insert row above button (retrieve position of button) | Excel Discussion (Misc queries) | |||
| How do I lock a radio button group if a N/A button is selected | Excel Discussion (Misc queries) | |||
| Can't select macro button after other button is pressed | Excel Programming | |||
| Delete a custom button by holding down the ALT key and dragging the button off the toolbar | Excel Programming | |||
Linear Mode
