This is also posted on Stack Overflow - http://stackoverflow.com/questions/4...99632_43777862
I have been learning VBA as I go when developing a spreadsheet, I am stuck with a particular issue though.
Please see below code;
My issue is the "If active row does not have Event Held data, ask if wants to add or not" part, the MsgBox pops up on every SearchButton_Click. Where I only want it to popup when the searched booking number has no data in column K.![]()
Please Login or Register to view this content.
I'm sure it's something simple and I'm probably going to feel like an idiot, but I just cannot work it out.
NB I have tried putting my code in before the Loop however it just gives me a Loop error.
Bookmarks