yorkie
09-24-2011, 03:04 AM
I've searched the web and still can't find anything that could shed some light on this.:banghead: Can any one advise.
I currently have a macro-enabled workbook that when the user puts an entry into column L they must also put an entry in column M and N.
the range for entry is L5:L35 with the corresponding range for M and N being the same number of rows.
What i need to do is
When an entry is put in L5 the user HAS to put a valid entry in M5 AND N5.
Currently the values for the ranges are
L column - any number from 0.5 to 24
M column - a drop down list is used to select names
N column - a drop down list that has three options, i.e Left, Right, Unknown.
E.G It needs to be so that once they enter something in L5 they HAVE to enter something in M5 AND N5 or they can't move to another cell.
Im i making sense? ANy help would be greatly appreciated.
Thank you.
I currently have a macro-enabled workbook that when the user puts an entry into column L they must also put an entry in column M and N.
the range for entry is L5:L35 with the corresponding range for M and N being the same number of rows.
What i need to do is
When an entry is put in L5 the user HAS to put a valid entry in M5 AND N5.
Currently the values for the ranges are
L column - any number from 0.5 to 24
M column - a drop down list is used to select names
N column - a drop down list that has three options, i.e Left, Right, Unknown.
E.G It needs to be so that once they enter something in L5 they HAVE to enter something in M5 AND N5 or they can't move to another cell.
Im i making sense? ANy help would be greatly appreciated.
Thank you.