Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default macro adding a number to a number already in a cell

Try this with a inputbox Todd

Sub test()
mynum = Application.InputBox(prompt:="Enter a number", Type:=1)
ActiveCell.Value = ActiveCell.Value + mynum
End Sub


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Todd" wrote in message ...
I am entering numbers like "5.725" into a cell next to a
given part number.

then later on I might come back to the same cell and need
to enter and additional amount like 4.5

so I need to hit the = sign and get the cell to
say "=5,725+4.5 becuase I need to see the detail behind
the total of the cell.

can a macro be made that will take me to edit mode simular
to f2 but will automatically put the = in front of the
original number then jump to the right of it place a + and
be ready for me to type the 2nd value

so :

go to a cell with a number already in it

hit the macro

get my cursor blinking for data entry with the original
number still intact and an = to the left of it and a + to
the right of the original number

=5.725+"I type the new number here and hit the green check

thanks



Reply
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
Adding to number to get the cell Maracay Excel Discussion (Misc queries) 4 January 1st 10 10:32 AM
Adding number within a cell Jon A Excel Worksheet Functions 5 February 4th 08 04:06 PM
Adding a number to a cell that already has a number. paula Excel Discussion (Misc queries) 3 January 15th 08 04:41 PM
adding number in next cell ED New Users to Excel 4 January 11th 06 09:44 PM
adding number only if CDN is displayed in next cell ED New Users to Excel 2 December 21st 05 10:39 PM


All times are GMT +1. The time now is 07:20 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"