|
There is lots of help in the editor, if it is installed - you might need to add a feature to Office. Or go to http://msdn.microsoft.com and look for the Office development area.
You can use what is called an input box (function is called just that - InputBox).
It won't work here, I think, but a nice way to get some code is to record a macro. You'll get the source in the VB editor and see what Excel really does.
HTH Vern At 12:08 PM 8/2/2005, you wrote:
I want to be able to click a button, have a pop up show up and ask for a value. Then Add that value I entered to another cell and then replace that value. So let's say A1 has a value of 5. I want to add 3 to it. So now it is 8. I have done no VBA. Where can I start looking for help for this? This is the basics of what I want to do. I do want to do more than that, but I just need a start. -- Mike Wills koldark@xxxxxxxxx http://mikewills.name Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list. -- This is the PC Technical Discussion for iSeries Users (PcTech) mailing list To post a message email: PcTech@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/pctech or email: PcTech-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/pctech.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
