Hi guys,
I'm come up to abit of a problem at work, on an excel form that we use I need it to automatically enter a value in a cell depending on if the value in another cell is "0"
basically
if C25 equals "0" then C26,C27 and C28 need to display "N/A"
the value in C25 is selected from a list
it has to be done in VBA and happen on its own if C25 = "0"
C26,C27 and C28 also need to be able to be edited after
Thanks
AMR
I'm come up to abit of a problem at work, on an excel form that we use I need it to automatically enter a value in a cell depending on if the value in another cell is "0"
basically
if C25 equals "0" then C26,C27 and C28 need to display "N/A"
the value in C25 is selected from a list
it has to be done in VBA and happen on its own if C25 = "0"
C26,C27 and C28 also need to be able to be edited after
Thanks
AMR