View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BB Ivan BB Ivan is offline
external usenet poster
 
Posts: 17
Default 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