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

 

[bebo021999]

It depends on what is your UDF doing.
In this sample, If you choose cell A1, cell A2 will call an UDF to sum A3 and A4

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address(0, 0) = "A1" Then
    Range("A2").Value = myUDF
End If
End Sub
Function myUDF()
    MsgBox "Hello, this is my UDF"
    myUDF = Range("A3") + Range("A4")
End Function

A2 only be updated when A1 is selected.
If it does not work, try to share your UDF script.

UDFsample.xlsm

drive.google.com

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Run an UDF by click on a cell

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?

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.