changing the appearance of a cell accessed

  • Thread starter Thread starter James Cornthwaite
  • Start date Start date
J

James Cornthwaite

I have written the macro as below



Function FindOldNominal(NomCode, Range)

FindOldNominal = WorksheetFunction.VLookup(NomCode, Range,5,false)
End Function


My question is what code can I insert that will change the colour (say) of
the cell accessed by this function.
My aim is to show all the cells accessed (and contents returned) by changing
their colour so I know which cells in my table have not yet been looked at.

Thanks
James
 
Nothing.

from this context, A function can do nothing more than returning a value to
the cell in which it is located - just like the built in functions.

You could possibly have each function update a defined name or public
variable or something and then use the calculate event to access that list
and color the cells.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Color contents of a cell accessed by a function? 4
My first macro, uses Vlookup but doesnt update unless hit I enter 3
Accessing a variable(a range) and modifying it 1
Macro Query - 6
Add comments via a function - please could you ammend my code/ pseudocode to work 6
My first macro, uses Vlookup but doesnt update unless hit enter 1
using excel functions in a macro - not familiar with macros at all 6
VBA set thick borders around non empty cells in range 0

Back
Top