Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF in vba
Hi, I would like to carry out an IF function so that if one cell has a text
of " Note", text of "N/A" is put in another cell ie =IF(C28="Note","N/A", ""), but I want to do this in VBA so that I can still type in the cell that the answer would be put into, ie if the text isnt "Note" I want to be able to manually write other text or values in the cell. I want this to be automatic without running macros, so that "N/A automatically appears if "Note" is written is the reference cell. VBA is not my strong point but I'm guessing that an IF statement can be used on the correct sheet in Excel objects. |