 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006formula
i want to make a formula for the same cell which i want to enter data in it kufo79 wrote : > i want to make a formula for the same cell which i want to enter data in it You are not supposed to enter any data if you would like to have a formula in the same cell, what you enter would replace the formula. The only way to do this would be to have a VBA Macro running in the worksheet which checked a particular cell (or cells) for input and calculated a function on them when data was entered. Matt http://teachr.blogspot.com - For Excel Tips and Tutorials > kufo79 wrote : > > i want to make a formula for the same cell which i want to enter data in it > > You are not supposed to enter any data if you would like to have a > formula in the same cell, what you enter would replace the formula. This cannot be done!! Regards. Bill Ridgeway Computer Solutions >i want to make a formula for the same cell which i want to enter data in it |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.