I have created this macro to search for friendly and enemy clans in a game. (There are hundreds, but I have only put 4 in for testing purposes).
The macro works fine, but I'd like the message boxes to be coloured, red for enemy green for friendly for instance.
I have absolutely no idea how to go about it. Can anyone help?
Briefly the macro is in search sheet, and data is in hidden sheet called clans. I have done that so that it can't be edited by users. I unlock and relock within the code.
I protected the search sheet, but can't remember if I unlocked it - so if you need to log in the password in BBC. This is temporary, I will do something more permanent when finished.
Thanks
Kev
Bookmarks