View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jonco jonco is offline
external usenet poster
 
Posts: 53
Default Puting data from an input box in two cells

I have an input box that askes the user for a figure. I want that figure
to go into the active cell and also into another cell (O2), but I don't want
to "Select" the other cell. I want the active cell to remain where it is
because the macro does some other things from that location (offsets etc.)

Here is where I get the figure....

AmtPaid = InputBox("Amount Paid?")
ActiveCell = -AmtPaid ' Negative Amount

Now I want to take whatever is input there and also put it into cell O2
(without actually selecting O2)

Thanks for any help you great guys can give me.

Jonco