| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Color a result cell in a user defined function
Hi !!
I had written a personal average function in VBA: myAverage(ByVal myRange As Range) As Single the result is correct, but now I am interesting in coloring (under certain conditions) the background of the cell where I have written my formula. How can I identify the cell where I have written my formula ? ActiveCell doesn't fit for me because it may not identify the correct cell (if I move it for example). Could you help me please, Nico |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Color a result cell in a user defined function
Application.Caller the renvoie la référence (Range) de la cellule appelante.
Cordialement, -- AP "aaa" a écrit dans le message de news: ... Hi !! I had written a personal average function in VBA: myAverage(ByVal myRange As Range) As Single the result is correct, but now I am interesting in coloring (under certain conditions) the background of the cell where I have written my formula. How can I identify the cell where I have written my formula ? ActiveCell doesn't fit for me because it may not identify the correct cell (if I move it for example). Could you help me please, Nico |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A correct IF function doesn't show the function's result in cell | Excel Discussion (Misc queries) | |||
| How to Convert Figures into Text in Excel | Excel Worksheet Functions | |||
| convert numbers to text | Excel Discussion (Misc queries) | |||
| How to .. | Excel Discussion (Misc queries) | |||
| Amount or Numbers in Words | New Users to Excel | |||
Linear Mode
