Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
input data dependent on other cells | Excel Worksheet Functions | |||
specify a range of cells for data input, down then over | Excel Discussion (Misc queries) | |||
Data input in cells | Excel Discussion (Misc queries) | |||
Msgbox - Puting current date in a message box | Excel Programming | |||
how can deactive cells to input data | Excel Programming |