Create a form button
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
|