Forum Discussion
Solved
Aid data entry or mandatory cells prompt when a cell is filled
Hi, I'm looking for someone to assist me with my excel project. I want a pop form to appear when a cell is selected, to assist enter data in that cell and several other specific cells, either in th...
Hi,
Could all this be achieved by using data validation rather than a macro? You would be able to set the values for the cell, have an input message when the user selects the cell and have an error alert if invalid data is entered.
Rich
I think this should do it, just change cell reference as required
=IF(AND(A1="",A4=""),"",IF(AND(A1>0,A4=""),A1,A4))
Rich
=IF(AND(A1="",A4=""),"",IF(AND(A1>0,A4=""),A1,A4))
Rich
Hi Rich,
This makes perfect sense. I will try it some day. I managed by equating the adjacent cell with the empty string("").
Thank you for the timeous response.
This makes perfect sense. I will try it some day. I managed by equating the adjacent cell with the empty string("").
Thank you for the timeous response.