Colour and font size in message popup

Hi,

Ive had some great help making a code to force a pop up window to appear when i certain vailue is reaced in a particular row.

the code is below

Just wondering if itis possible to change the background colour of the message box (to RED as it is a critical warning) and to enlarge the font size as well



THE CODE

Please Login or Register  to view this content.

No, not in a message box. But add this, should help a little.

Please Login or Register  to view this content.

You can create a customized userform instead. In that case you can use a specific background, etc.

Have a look at the attachment. I added the same code, but instead of calling a Msgbox, I called Userform1.

abousetta

Hello,


ive opened it up to take a look and i am getting an error like this


COMPILE ERROR
VAIABLE NOT DEFINED


Then it opens the VBE and highlights the thrid row in yellow

Please Login or Register  to view this content.

Can you upload your original workbook so that I can the userform to it? Else drag and drop the userform from the example I gave to your workbook and replace the line in your workbook that begins with Msgbox with the line from my workbook that starts with Userform1.show.

Also use code tags around your vba code as per forum rules or else you could get a warning from one of the moderators.

Here is a simpler example. If macos are enabled, once you open the file, the userform will appear.

Gday,

nope that fixed it... thanks....


silly question... im trying to add an "OK" or "Close Button on the pop up but cant seem to work it out?

I added a commandbutton, renamed the caption to "OK", changed the backcolor, and added the code "Unload Me". Therefore, clicking on it will unload (close) the userform.

There a lot of step by step tutorials on userforms. I find them very useful especially if you don't want people playing with the original worksheet and potentially messing up the formulas, formatting, etc.

Good luck.

abousetta

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks.

Thanks for the feedback.

Good luck.

abousetta

Hi,

Replace the code in the userform with this:

Please Login or Register  to view this content.

Replace the code in sheet1 with this:

Please Login or Register  to view this content.

Put this code at the top of module1:

Please Login or Register  to view this content.

What this will do is create a loop so that keep the value of Cell A8 the same until the user clicks OK on the userform. That way, the user can't accidentally keep scanning away without confirming the message on the userform.

Hope this helps.

abousetta

Yes, that's because the variable A wasn't originally declared. Replace the declaration "Dim Scan$" with "Dim Scan$, A&".

abousetta

Try the attached.... Debugging can be a bit of a trial and error until you pin it all down.

Hi,

I can't test because I don't use scanners but obviously they can bypass the normal controls that don't allow users to work on the worksheet while the userform is in modal mode. What I have done is put in an If statement that should trigger Cell A8 to go back to the original value until you click OK on the userform. Hopefully the tweaks work this time around.

abousetta

Let me ask around... maybe someone has a scanner and debug this. I'm trying to imagine in my head the process but without being able at to debug we could be doing this for a while.

Thanks Kyle. I didn't know that scanner hit the return button, but can see the logic behind that. Attached is an example replacing the button with a label.