Advertisement

04.16.2008 at 07:57PM PDT, ID: 23329653
[x]
Attachment Details

Change MsgBox colour in Ms Excel using VBA

Asked by jannhan in Microsoft Excel Spreadsheet Software, Visual Basic Programming, VB Script

Tags: ,

I have a checkbox in sheet1 when checked, a Msgbox will appear. Is it possible to change the colour of the msgbox to red instead of the default colour?

Private Sub CheckBox1_Click()
If Sheet1.CheckBox1.Value = True Then
MsgBox "Red Alert!", vbCritical
End If
End Sub

ThanksStart Free Trial
 
Keywords: Change MsgBox colour in Ms Excel usi…
Title
1 VBA Message Boxes (MsgBox)
2 MsgBox - Yes, No and Cancel
3 If an autopopulated cell is clicked, ms…
4 msgbox vbyesno
5 bullet in VBA msgbox
6 MsgBox
 
Loading Advertisement...
 
[+][-]04.16.2008 at 08:24PM PDT, ID: 21374003

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Excel Spreadsheet Software, Visual Basic Programming, VB Script
Tags: Ms Excel, VBA
Sign Up Now!
Solution Provided By: nutsch
Participating Experts: 2
Solution Grade: B
 
 
[+][-]04.16.2008 at 10:10PM PDT, ID: 21374316

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628