Basically, I have a macro where it goes through all my data, loops row by row, and if a certain field is missing (for example, a date), it pops up a userform, in which the user can enter in the missing information, and it then populates back into the data. The problem is, in order for the user to find the missing data, they have to use other spreadsheets. With a userform running, they cannot open up other spreadsheets. I tried using vbModeless, but it ended up running through the rest of my macro (what happens after all the data has been entered with userforms) and misses that whole step. So vbModeless doesn't work. I need to make sure they enter the data into the userforms before the rest of the code progresses.
Is there any way to do this? Basically, to have a userform open, but be able to open up other spreadsheets simultaneously, without having the rest of my code run? Thanks!
Is there any way to do this? Basically, to have a userform open, but be able to open up other spreadsheets simultaneously, without having the rest of my code run? Thanks!