Hi. Please help me achieve this scenario:
On Column C (either on C3,C100,C24,and so on), I would like to put a formula that when integer is entered, the result will be displayed right away after hitting the ENTER key. For example:
I enter 4 on C4 then hit enter. Result should be 1.8 (that is 4 * 0.45) on the same cell C4
I enter 6 on C103 then hit enter. Result should be 2.7 (that is 6 * 0.45) on the same cell C103
and so on
Please help. Thank you.
Hi, itselflearn,
right click worksheet tab, View code, paste code into the code window, activate macros in options:
Ciao,
Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Holger.........Thank you very much. It works perfectly. i really appreciated your help. Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks