Re: Excel Macro Question

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Alt-F11 takes you to the VB Editor, IIRC. Or go to the Tools menu, open the 
Macro item and go to the editor.

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.