UDF Not Woking Unless Commited Using Enter Again

[NeedForExcel]

Hi,

I have a UDF that generates a String..

Please Login or Register  to view this content.

On Cell B4 on another sheet, I have this formula which calls the UDF and adds Text at the start and the end to generate a string that is used somewhere else -

Please Login or Register  to view this content.

The Only issue is, where the parameter on the source sheet changes (which affects the UDF) I need to hit enter once for the UDF to return the actual values..

I added Application.Volatile (True) too, but does not help..

I also noticed, If I put the parameters on the same sheet where I am trying to run the UDF, it happily works..

Any views please?

[GC Excel]

Hello,
Maybe by forcing Excel to recalculate when you change a value in your parameter list.
Add this code to the ReadMe sheet :

Please Login or Register  to view this content.

[MrShorty]

The main thing I see is that you are not passing any arguments to the function, and you have coded the function so that any information it needs is hard coded into the function. A good UDF should not get its own information from the spreadsheet. Everything it needs (such as LF and the information in column I for CellValue) should be passed to the function through the argument list.

If you are new to coding UDF's, I would suggest a page like this: http://www.cpearson.com/Excel/Writin...ionsInVBA.aspx to get a feel for the basic ideas and "best practices" around creating a UDF.