Hello:
EXCEL.
I am trying to find the best way to create either a formula or a macro/button for the following issue:
I have a spreadsheet, which has a specific daily total on cell G19 (Ex G19 = 2,000,000)
cells G21 (Ex. -300,000)and G23(Ex. +300,000) are use to enter specific amouts that will either add or subtract from G19. The answer to this addition/ subtration is recorder automatically to cell G25.
EX. 2,000,000
-300,000
= 1,700,000
The result on cell G25 (1,700,000) will be the beginning balance for the following day. My problem is, that when I open the spreadsheet on a daily basis, I have to Manually change the amount on G19 to the new Begining balance (Ex. G19=2,000,000 change to G19=1,700,000) and I want to make it possible, so that this change takes place automatically on a daily basis, without having to always change it manually. Maybe there's a formula, a macro, or even a button that can be created to perform this fuction. Can some one please HELP!!
Thanks,
AH.
Help creating a Excel formula or a VB Macro for a specific function
ag1206
From your description it sounds as though you are trying to use the VB within Excel is Visual Basic for Application. VBA is a very different product from VB.NET and there are some other locations where youy will probably get a quicker and better response to your VBA questions.
You may find more assistance in following which specifically deals with VBA development.
http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=74&SiteID=1
Or if you are using VBA from within on of the office applications
Office Automation: office.developer.automation newsgroup
http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.office.developer.automation&lang=en&cr=US
Or the Office Newgroups
http://www.microsoft.com/office/community/en-us/default.mspx d=1
Hope that helps
If this is trying to do the following using a VB.NET application then please provide some details on the code you are currently using.