KZNSeagull
Well-known member
If you add the line
application.volatile
at the beginning of the function then every time you press F2 and return it will refresh.....
...I think.
So it does! (well F2 and then tab) Well done that man!
If you add the line
application.volatile
at the beginning of the function then every time you press F2 and return it will refresh.....
...I think.
I think wrong. The latter is no different from KZN's edit function and the former doesn't get recognised by the application.volatile line. I'll crawl back in my hole.
This is the stuff of dreams.
Colour numbers are here: http://msdn.microsoft.com/en-us/libr...ffice.15).aspx
I'm going down a different route here and should point out I use libre office but can program my own accounts software.
I would have three columns for the figures. 1 = output (invoice total) 2 = input (payment made) 3 = balance. Expanding this to include invoice numbers, dates & customer name.
What does the '9' do?