[ExcelVBA] UDF not updating automatically

 

I have made a userdefined function, which Works almost properly.

Initially the results are correct. 

When I change some input, the results does not change.

When I try to recalculate (f9) theres no change.

If I edit (that is F2 and Return) all cells With the UDF they change.

How can I make the UDF update automatically?

This is my UDF:

Function kommuneriteam(kode As Integer) As String

Dim STRENG As String

For Each TALLKODE In Range("F6:F36")

    If TALLKODE = kode Then

        STRENG = STRENG & ";" & TALLKODE.Offset(0, -4).Value
    End If

Next

kommuneriteam = Mid(STRENG, 2)

End Function

Thanks in advance!

Regards

Torstein

__._,_.___

---

Posted by: Torstein Johnsen <sejohnse@yahoo.no>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
------------------------------------

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___