Hi,
I Want to be able to write in two cells, and that the other cells automaticly calculates a value in the other one, and vice versa.
In column A i will have Liter, and in column B i will have gallon. If i write in column A it gives output in column B as gallon, and if i write in column B it gives output in column A as liters.
Is this possible?
Thank you!
Yes, only with VBA, no formulas (but as this is posted in the VBA forum...)
Use the WorksheetChange event to determine which cell (Col A or B) was changed, do the appropriate calculation with the input value and place the result in the other cell. You will need to disable Events to prevent cascading events (one cell changes another which runs the code again and changes the first which runs... Eventually Excel falls over).
Description only - this is easy code with a caveat (cascading events) and is an ideal learning experience.
Last edited by cytop; 10-04-2016 at 04:09 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks