Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by crustycollins
-
save the previous number and put in another cell
It updates through a dde connection. I can not change that code and the frequency of the updates are determined by the source. How about returning the value to a specific cell?- crustycollins
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
save the previous number and put in another cell
I get live data into a sheet. I want to make a copy of the current price and save it untill that price changes. When the current price does change, move the saved price to a specific cell. I guess there is no real need to use an array but I can not figure out how to assign a specific cell to...- crustycollins
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
save the previous number and put in another cell
Ok, I have been working on this for a couple of days... I am new to doing this kind of thing in VBA so it may be a bit messy. I get live data through DDE. I want to save the previous number and display is no matter what the current number is. This was easy when I only had one price ( only...- crustycollins
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
