Run an UDF by click on a cell

[m_hakimi_a]

Hi, I'm beginner. I wrote an user defined function in excel and it works good.
I want to run this UDF by click on cell(1,1). How can I do that?

 

[6StringJazzer]

A UDF is a Function that takes arguments and returns a value, and is typically written so that is used in a cell, and that value is returned to a formula. Running code by a click is an entirely different thing. You cannot invoke a Function with arguments by using a click. We need more information about what you want to do, and it would also help to have the code for your function (paste into your post using CODE tags).

 

[m_hakimi_a]

A UDF is a Function that takes arguments and returns a value, and is typically written so that is used in a cell, and that value is returned to a formula. Running code by a click is an entirely different thing. You cannot invoke a Function with arguments by using a click. We need more information about what you want to do, and it would also help to have the code for your function (paste into your post using CODE tags).

Thank you for reply
My UDF has no argument, I want to run it by click on a cell A1.

 

[6StringJazzer]

Even if it doesn't take arguments, it returns a value. Please show the code.

 

[Skyybot]

Thank you for reply
My UDF has no argument, I want to run it by click on a cell A1.

Sounds like you have a Subroutine and not a UDF (User Defined Function). UDF's are called just like any other built-in function. By typing something like; =SUM(A1,B1) in a cell. A1 and B1 are the arguments.

Subroutine:

Sub mySub()
MsgBox "Hello", vbOKOnly, "Subroutine"
End Sub

UDF

Function myFunc(arg1,arg2)
myFunc = arg1 + arg2
End Function

 

[Skyybot]

Anyways, if you want to run a Subroutine by clicking in cell then you have to call your Subroutine from the Sheet code module.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = Cells(1, 1).Address Then Call [YourSubroutineNameHere]  'no brackets around your Subroutine name
End Sub