what the description says. if the value of a certain cell on worksheet2 meets a certain condition, say, between 3 and 12, then a pop up calendar will appear on worksheet1 for user to click on a date. this date will be populated in a cell on worksheet2.
so, for example, user is entering 'x's in a row on ws1. I have a counter in a cell on ws2. when the user puts in the third 'x' on ws1, a popup calendar will appear to click on a date. the counta formula is in a cell on ws2. the condition on ws1 would be based on that. thank you.