Click to See Complete Forum and Search --> : auto refresh


foongkim
October 17th, 2001, 03:59 AM
hi,
i would like to ask some question concerning VBA.
hi,
i had inserted the an excel chart in my form using OLE. Everytime, to update the chart, i need to double click on it, which will bring me into the Excel application.
Is there any other ways to automatically refresh my chart on the form when i change the value in the same file.
Hope someone can help me out