LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
input data dependent on other cells confused deejay Excel Worksheet Functions 4 October 16th 08 02:56 AM
specify a range of cells for data input, down then over jmirer Excel Discussion (Misc queries) 1 November 30th 07 04:38 PM
Data input in cells RichP Excel Discussion (Misc queries) 8 March 19th 06 09:56 PM
Msgbox - Puting current date in a message box rglasunow[_4_] Excel Programming 5 January 23rd 04 04:45 PM
how can deactive cells to input data Kaveh_Alborz Excel Programming 0 January 10th 04 03:53 PM


All times are GMT +1. The time now is 02:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"