Forum Discussion
JGB82
Jan 11, 2023Copper Contributor
UDF not working in Excel 365
I have made a new funcion via VBA and put it in its own module, so not in the workbook or something, I made a new module. It's a function for giving back the background color code of a selected cell...
HansVogelaar
Jan 11, 2023MVP
That's strange - there is no reason it wouldn't work. The function is correct (and it works for me).
mtarler Riny_van_Eekelen mathetes NikolinoDE SergeiBaklan
Does any of you have an idea? I'll attach the file here.
NikolinoDE
Jan 12, 2023Platinum Contributor
It also works for me without any problems.
If it doesn't work for users for whatever reason, here are some links with alternative suggestions.
How to determine and identify the background color index of cells in Excel?
Formula to find the cell color value (RGB & Color Index Value)
The GET.CELL Function (file is inserted)
Otherwise, one would have to have detailed knowledge of the digital environment in order to discover the source of the error with the elimination process.