Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 313
Default How do you update a cell after an operation on it.

Can you do a calculation on a cell, get the answer and then post it back to
the same cell?

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,124
Default How do you update a cell after an operation on it.

You need to learn how to post and you need to learn patience to wait for an
answer. You need a worksheet_change event macro.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tony" wrote in message
...
Can you do a calculation on a cell, get the answer and then post it back
to
the same cell?


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,722
Default How do you update a cell after an operation on it.

Not without using VB.

Sub CircularLogic()
Range("A1") = Range("A1").Value + Range("C1").value
end sub

You can then either assign the macro to a hotkey, a command button, or an
event (in VB)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tony" wrote:

Can you do a calculation on a cell, get the answer and then post it back to
the same cell?

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,722
Default How do you update a cell after an operation on it.

My apologies. I forgot to mention that you *can* do it with just formulas, if
you turn off automatic calculation. (tools-Options-calculation, set to
manual, iterations to 1).

Now you could put in A1
=A1-C3
and everytime you press F9, XL would perform a calculation.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tony" wrote:

Can you do a calculation on a cell, get the answer and then post it back to
the same cell?

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
Data Validation lists update orginal cell with list update [email protected] Excel Worksheet Functions 3 July 11th 08 07:56 AM
can excel produce text in a given cell as a result of a boolean operation? Richard Erlacher Excel Discussion (Misc queries) 5 October 26th 06 09:39 PM
Advanced formatting operation on a cell Muhammed Rafeek M Excel Discussion (Misc queries) 5 July 21st 06 10:50 AM
Using a Cell Operation for insertion into a Formula JCary Excel Discussion (Misc queries) 1 March 4th 06 01:22 AM
what does $ operation mean JO New Users to Excel 1 December 16th 05 12:42 AM


All times are GMT +1. The time now is 06:46 PM.

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

About Us

"It's about Microsoft Excel"