My terminology might be wrong... What I need to knwo how to do is to get a series of calculations written in a macro to constantly update the worksheet. Currently, I enter the numbers, press Alt-F11, run the macro, and return to the worksheet to see the updated figures. How do I make this update automatically?
Thanks!
titanxt,
I moved this question to programming as per forum rules below. Please do read them before posting again.
Can we see your code (please wrap the code as per forum rules) and/or explain the trigger
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
I apologize... where did this thread get moved to?
Thanks!
I'm not really sure why you need this instead of formulas, but you could use a worksheet event, such as the SelectionChange event. Search the Forum for examples.
To access the sheet module, right click on he sheet's tab & choose view code. Then set the left hand drop down to worksheet, use the right hand drop down to find the required event.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks