Excel pop up message

[BlackPanther]

Hi all,

I need to create a pop up message for a whole column/ or A1 : A 60. if the value in B1 is greater than or equal to 100

I am new to VBA in excel

 

[Caribeiro77]

Do you want a pop up message if any of the values from A1:A60 is > or = to the value in B1?

 

[BlackPanther]

Yes @
Caribeiro77

 

[Caribeiro77]

Try:
Press ALT+F11
Insert module
And paste the bellow code ( you may have to change sheet name)

Sub findvaluegreaterigualto()


Dim findvalue As Range


Set findvalue = Sheet1.Range("A1:A60")


findvalue.Font.Color = vbBlack
findvalue.Interior.Color = xlNone


For Each cell In findvalue


    If cell.Value >= Range("B1") Then


      MsgBox ("You have values that exced value in cell B1")


        cell.Interior.Color = vbRed
        cell.Font.Color = vbWhite


    End If


Next cell


End Sub

After this you can craete a excel shape directly on the sheet and assign the macro..

 

[BlackPanther]

Thanks
Caribeiro77

it worked.

 

[BlackPanther]

Caribeiro77

I have a query , the code that you provided worked very well as per my need.

Just imagine the same scenario , but the column A is automatically filled by the computer . and we see the result after the execution . is there any code for such a scenario?


when i open the excel sheet the colums greater than or equal to 100 whould be highlighted. ( no pop up )

 

[Caribeiro77]

but the column A is automatically filled by the computer

How does this happen's?
And is it all column A or just the same range of your post #1 (A1:A60)?

when i open the excel sheet the colums greater than or equal to 100 whould be highlighted

Which columns?

 

[BlackPanther]

column A , The code you provided works good .

But what i mean is , Column A will be entered automatically by the system during execution of a program.

Can we write a same code , but Cells greater than or equal to 100 will be highlithed when we open the excel sheet in advance

 

[Caribeiro77]

Do you want that to happen only when you open the sheet or do you want that to happenwhen it hoppen's and also every time the b«numbers change( after the excecution of the program)?