VBA Control Button Help

[Vittorio]

Hi,

Here is what i am currently using as code for one of my 56 or so buttons:

Please Login or Register  to view this content.

And here are the challenges i'm getting so far:

#1

The message box is only supposed to pop-up if "i" is not found on the "Subjects" worksheet. However, what i am getting is the msgbox even if "i" is found or valid. Is there something wrong with my syntax or the order it was written?

#2

How do i type the message box content so that it reads:

"Mathematics" does not exist. Please press OK and choose another button.

instead of:


Mathematics does not exist. Please press OK and choose another button.

Please note the "" marks.

#3

This is just an add-on question. For worksheets with multiple buttons, is there a way to format the code so that it works for all instead of typing it separately for each "i"?


Thanks guys. Looking forward to your help.

[D_Rennie]

hello, Try this, I will exit the sub before the error message if everthink ran fine, if not it will show the message. Also not the """" in the message itself

Please Login or Register  to view this content.

[D_Rennie]

sheet loop

Please Login or Register  to view this content.

[Vittorio]

Sorry for the late reply... Got caught up with work and family...

Your suggestion worked like a charm. Thanks!