input box

in column b, i have a list of days the employee in column a has for vacation (8 days,7,etc.) . in column c there are notes such as in year 1, the employee has off 8 days, but in year 2, the employee has off 10 days. when this happens, the cell in b contains "SEE NOTES" instead of the number of vacation days. is there a way to create an input box that pops up for every cell in column b that says "SEE NOTES" and allows you to enter a value that will overwrite what is in the box (or put the value in another column)? also, is it possible the input box populates with the notes from column c?

Here's a quick method to get an input box with what you've described.

HTH

Please Login or Register  to view this content.

The above will work, but since a Do loop is used, it may not look at all cells that you would like it to. For example, if one of the cells in column B is blank, but there is data below it, the Do loop will not work. In this case, a For Each loop will work better, which will look at each cell in column B that has a value:

Please Login or Register  to view this content.

HTH

Jason