Picking a row, while a Yes/No popup dialog box is up.
Posted on 2015-01-29
Is there a way to do the following.
Have a Yes/No dialog box popup, that if No is selected. Exit Sub. that is the easy part. Here we are verifying that the user wants to perform this task in case a button is click on by mistake. so if Yes is click that would mean to continue.
Then have another popup dialog box that states. Before continuing. Select a row (while the dialog box is up) that has the current date in column B, and then press the Ok or yes button. If if the date in the selected row is < today, go back and ask them again. (the selected rows date is < today, try again).
If the row select is = to current day, I have a macro to run, however when I do it, I cannot select a row while it is up.
How do I get a popup dialog box to allow the selecting of a row that is = to current date? We want to force the user to click on a row that has a currect date.