Function not Appearing in Macro List

[HCLax]

Hi,

I have a function that I am trying to run, however, it is not showing up on my Macro List. I have other Macros that are Subs showing up on my Macro List but no Functions. I have tried adding a Sub End Sub on either end of my Function but then the Macro wont get past the first line. The function looks like this:

Function flag_duplicates()
Dim value1 As Integer
Dim value2 As Integer
Dim toolid1 As String
Dim toolid2 As String
Dim Sum1 As String
Dim Sum2 As String
Total_VALUE = value1 + value2
If Total_VALUE = 0 Then
If id1 = id2 And product1 = product2 Then
flag_duplicates = "DUPLICATE"
Else
flag_duplicates = "--"
End Function

Thanks,
Justin

[Arkadi]

Why do you need it to show up on list? you usually call them within another sub, or in a cell formula, not assign them to a button? (I am guessing you want to assign it to some object since you have a list. What happens to the value of flag_duplicates afterwards?

[HCLax]

When I try to Assign the function to a Sub it will appear on the macro list but Excel will not allow me to hit the "Run" button. I want this Function to input "Duplicate" in the far right column for any rows containging duplicate values in both column A and Column B.

[Norie]

What is the function meant to do?

In it you declare and refer to a bunch of variables but those variables are never given values in the posted code.

Also, you don't normally 'run' functions, they are usually used to return values.

[Arkadi]

Hclax, what values is your function supposed to compare? Something is missing....

[Richard Buttrey]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Functions are not procedures and won't be listed in the macros window. You'll only see them in the function list when you type the name prefaced with an =.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)