In A7: =IF(NOT(ISBLANK(B4)), "Hello world", "")

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"vivitz " wrote in message
...
Hi everybody!

what i wanted in my workbook is that after a value is entered in a cell
(let's say in cell B4) and enter key is pressed, a message will
immediately appear in another cell (example, cell A7). what will i do?
help!


---
Message posted from http://www.ExcelForum.com/