0

I tried to refresh a cell function that returns the colorindex of a cell. 

Function doubled(RA As Range)

Application.Volatile
doubled = RA.Font.ColorIndex

End Function

I have seen this answer but it only updates for values : Refresh Excel VBA Function Results

braX
  • 11,506
  • 5
  • 20
  • 33
Pierre44
  • 1,711
  • 2
  • 10
  • 32
  • You can't. Changing colours will not trigger a recalculation, so you'd have to use something like a timer to recalculate everything periodically, which would be annoying at best. Best solution in my opinion is to rethink your entire approach to whatever you think you need this for. ;) – Rory Oct 17 '18 at 11:49
  • @Rory thanks, At least I know that Application.volatile brought me as far as possible for a clean code :) – Pierre44 Oct 17 '18 at 12:06

0 Answers0