Excel VBA For Creative Problem Solving Part 1 Assignment 4

VERY new to VBA, first class I have taken so far. I am getting Compile error: "Ambiguous name detected: identifier" when trying to run the assignment below. The assignment doesn't allow you to change the name of subs or functions. The "Identifier" is both a sub and a function. If I change the sub name to "IdentifierS I am able to F8 through the code fine. Is there a way to run the function as named or did I miss something? Thank you in advance.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I think it's reporting a problem because you have both a Sub and also a Function called Identifier.

Change the name of one of them and it should be resolved.

There may be some obscure way of overcoming this issue while using the same name for both a Sub and a Function- I don't know it (maybe something to do with class modules , I have zero idea).

I'd personally check once with the teacher if it's at all possible to clarify if there's an error or not!

EDIT- Another potential error is that the Sub Identifier uses nr to identify a numeric value but it assumes that the count of the content in column A is at least 2 cells (i.e. a minimum of 2 cells in column A have something in them), otherwise nr returns a zero or negative value, both of which trigger errors.

Hi Astec,

Welcome to the forum!!

You can't have the same name for a macro and a function in the same module but if you put the Identifier function into its own standalone module (which I have called modFunctions) like so...

Please Login or Register  to view this content.

...you can then call it from the Example macro like so:

Please Login or Register  to view this content.

To be consistent I'd also move the Key function into the modFunctions module and maybe rename Module1 as modCode.

Regards,

Robert

Moving it to module2 worked. Thank you very much!

You're welcome 👍