How to Trigger the Change_Event without actually changing the value of a cell

[JamesGoulding85]

Hey,

I have a function that is triggered by a change event, I want to be able to iterate through a column of cells triggering the change event row by row. I don't want to actually change the cell contents I simply want to trigger the change event as im trying to use it as a refresh button.

hope that makes sense

Thanks

[JosephP]

hope that makes sense

not really-why can't you call the function directly instead of the change event?

[Norie]

Or, if it's a UDF, calculate.

[Andrew-R]

How about using the selection change event?

[JamesGoulding85]

Hi all thanks for the responses, after relooking at my code I have realised that what I have done is not possible anyway, probably due to bad coding on my part as im new I have intwinned the change event and the function module meaning one can not operate without the other so pointless having a separate module. I will have to reconfigure it all to be standalone and will then just recall the function.

Thanks

[JamesGoulding85]

Hi all thanks for the responses, after relooking at my code I have realised that what I have done is not possible anyway, probably due to bad coding on my part as im new I have entwined the change event and the function module meaning one can not operate without the other so pointless having a separate module. I will have to reconfigure it all to be standalone and will then just recall the function.

Thanks