Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm developing a macro to create buttons and want to feed the process with
variables for placement and size. I'm using this command: ActiveSheet.Buttons.Add(355, 56, 60, 9).Select where I'm trying to substitute a variable or variables for the values. When I do I get an error telling me that this isn't optional. Is there any way to pass these values through a variable? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create a form button for email | Excel Discussion (Misc queries) | |||
Button to create a new form | Excel Worksheet Functions | |||
I am trying to create a form in Excel. In my form I want to be abl | Excel Discussion (Misc queries) | |||
How to create a form to insert a hyerlink.VBA code to create a for | Excel Discussion (Misc queries) | |||
How do I create a button on the toolbar that will start my form? | Excel Discussion (Misc queries) |