Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function won't update a cell
Hi, This has been asked before but I've not found anything recent. I'm
using Excel 2003 with either VSTO or VBA. I have an RTD server which works fine, but as we know RTD does not trigger the worksheet's change event. There have been lots of suggestions that don't work around this, but I thought I was getting close with this one. Create a function which points at the cell to monitor and then do something, something like this: ---------------------------------------------------------------------------------------------------------------- Public Function Test(r As range) As String On Error GoTo Failed: r.Font.ColorIndex = 3 Test = "5" CleanExit: Exit Function Failed: Debug.Print Err.Description End Function ----------------------------------------------------------------------------------------------------------------- The function fires at the correct time, yay I thought, except you'll note the line which changes the color. This does not work. No error, it just doesn't do anything to the range. I've tried all sorts of things, but I don't seem to be able to affect other cells from this function. Does anyone have any ideas of why? If it's just designed that way, does anyone else have any idea of how to generate an event when RTD data arrives? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation lists update orginal cell with list update | Excel Worksheet Functions | |||
Forcing cell with user function to update on workbook open? | Excel Programming | |||
How to make a function in a cell update | Excel Discussion (Misc queries) | |||
how to using Function update cell value | Excel Programming | |||
function need to return value and update one cell value | Excel Programming |