user function works in vba, but not when called from worksheet

**JasperD** · 02-28-2019, 07:08 PM

Hi all,

I have the very simple function below - it works fine when called from VBA (?ccf(range("A1:B10")), but not from worksheet "=ccf(A1:B10)" and I don't get why...

Please Login or Register  to view this content.

anyone any great idea?

**JasperD** · 03-01-2019, 03:33 AM

No one...?

The function detects if a cell is formatted as "bad" via conditional formatting (so the pink interior color, with red font) and counts the number of occurrences.
I really don't understand why it works from the immediate window, but not from a worksheet.

**bakerman2** · 03-01-2019, 04:18 AM

Read this and you'll know why it doesn't work in worksheet UDF but does in Immediate window.

It's DisplayFormat that's causing the isuue here.

https://docs.microsoft.com/en-us/off....displayformat

user function works in vba, but not when called from worksheet

LinkBack

Thread Tools

Rate This Thread

Display

user function works in vba, but not when called from worksheet

Re: user function works in vba, but not when called from worksheet

Re: user function works in vba, but not when called from worksheet

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] DLL function crash excel when called from worksheet

[SOLVED] Determine what called a user defined function?

[SOLVED] Sub works when debugging but not when called from another sub.

User Defined function getting called for all the formula calculation cells

Can a Function( ) called from within worksheet write to another cell?

[SOLVED] How to reference the name of the module in which a function is called in a worksheet

UDF working when called from Sub, doesn't work as worksheet function

Bookmarks

Bookmarks

Posting Permissions