Message Box Efficiency

Originally Posted by romperstomper

We'd need to see more of the code. I suspect an awful lot of it can be replaced with a loop but can't be sure without seeing it.

Hey rompertstomper

Essentially the code has a section of about 40 "if" statements with message boxes that just keep repeating... if A wasn't found? then if B wasn't found and so on... I'm happy with the rest of the code as of now... I was just curious if there was a creative way to turn these "if" statements with message boxes into a loop of a sort while still maintaining a customized message for each object that wasn't found. If B isn't found I want the message box to maintain that "B is not found" and so fourth for "C", "D" etc.

Hey Leith,

Thanks for the code, but maybe I described my question poorly... my search functions are all fine. I have no issues with that. Their are numerous find functions throughout the Macro. what I'm trying to improve is the message box statements. Before the macro starts doing actual calculations it goes through about 40 "if" statements with message boxes. If the search object (cat) isn't found it dislpays a message asking if I would like to continue anyway. I'm trying to find a way to make these 40 "if" statements more efficient while maintaining the object description in the display box. For example if "Cat" isn't found I want to specifically say "Cat is not found", and the same for dog, mouse, rabbit etc.

Hey RomperStomper

Most of the information is sensitive , but this is the just of the code, just imagine the "find" functions and the "msgBox" appearing a lot more often.

Thanks for your interest and help.

Please Login or Register  to view this content.

Hey SNB

This is great, but how would I implement it so I'm still assigning my columns and rows? If you look in the code I've quoted previously I had statments such as

Please Login or Register  to view this content.

Thank you soo much though!

Originally Posted by snb

Please Login or Register  to view this content.

Hey SNB,

I'm getting somewhere, I've taken a little twist on what you've given me. I want to keep the ColDog, ColCat, etc. variable names for future reference of people reading the code. So created the below code. But when I try to paste the information from the column I get "Run-Time Error 1004': Application-defined or object defined error"

Any thoughts?

Please Login or Register  to view this content.