Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh Excel cells on demand
I would like to add a button or a menu pick to Excel asking it to refresh all
cells which referances a user defined function in an Add-in. For example: Cells a1 =ExternalData("source1") a2 =ExternalData("source2") .... After button click ExternalData should refresh its data. Any help would be great! Thanks Roland |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh Excel cells on demand
Press Ctrl + A followed by F9 to refresh all cells with UDF
or, programatically, for an individual cell, say E5, Range("E5").Activate Calculate "Roland" wrote: I would like to add a button or a menu pick to Excel asking it to refresh all cells which referances a user defined function in an Add-in. For example: Cells a1 =ExternalData("source1") a2 =ExternalData("source2") ... After button click ExternalData should refresh its data. Any help would be great! Thanks Roland |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh Excel cells on demand
Thank you.
I try it but the function did not get called. -- Roland "AA2e72E" wrote: Press Ctrl + A followed by F9 to refresh all cells with UDF or, programatically, for an individual cell, say E5, Range("E5").Activate Calculate "Roland" wrote: I would like to add a button or a menu pick to Excel asking it to refresh all cells which referances a user defined function in an Add-in. For example: Cells a1 =ExternalData("source1") a2 =ExternalData("source2") ... After button click ExternalData should refresh its data. Any help would be great! Thanks Roland |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh Excel cells on demand
I have come up with two ways good or bad.
if I put Application.Volatile in the function it does get call each time. function ExternalData(dataSource) Application.Volatile .... end function The other way placed a button on the sheet sub buttonClick() me.Range("cellChange").value = "change" end sub This cause the function to fire also function ExternalData(dataSource,cellChange) .... end function -- Roland "Roland" wrote: I would like to add a button or a menu pick to Excel asking it to refresh all cells which referances a user defined function in an Add-in. For example: Cells a1 =ExternalData("source1") a2 =ExternalData("source2") ... After button click ExternalData should refresh its data. Any help would be great! Thanks Roland |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 will not refresh cells | New Users to Excel | |||
How do I set up a supply demand chart in Excel 2007? | Charts and Charting in Excel | |||
HOW DO I SET UP A DEMAND PLANNING EXCEL SPREADSHEET | Excel Discussion (Misc queries) | |||
how do i do supply and demand curves in excel? | Charts and Charting in Excel | |||
Load xla addin on demand for particular Excel instances | Excel Programming |