Calling function on button from excel sheet

[shantanuk]

Hi,

I want to call a function on click of button (form control) in my excel sheet. I require this since i need to pass the cell references to the vba code on click of the button

When I do assign macro to the button, it shows me only the sub procedure names in the vba code.

Could anyone please guide me?


Thanks,

Shantanu

[JosephP]

if you are not returning a value you don't need a function you need a sub-subroutines can take arguments too! :-)

however a sub that takes arguments will not appear in the macro list so you will have to manually input the routine name in the assign macro dialog and you will have to pass the reference as a string

I reckon there are probably better ways to do this especially if the cell you want to use is related to the position of the button or can be otherwise determined in code

[shantanuk]

Hi,

Thanks for the reply.

Could you guide me on a way where I can directly get the button position into the macro sub? If that happens, I would be more than happy.

Till then I will continue with the way you suggested above

Thanks,

Shantanu

[JosephP]

to refer to the cell containing the top left corner of the shape you clicked

Please Login or Register  to view this content.

[shantanuk]

Thanks a lot