Question description:
This user has given permission to use the problem statement for this
blog.
I have a table, where the cell data is streemed from outside, my table looks like this:
1. Table has some 250 rows;
2. 1st column (A) has the name and Column B has the rating
During any point if the rating is above 3 I would like to get a pop-up alert window were the message sould be like "Name:XXXXX just crossed rating: 3"
Solved by C. J. in 35 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
25/06/2018 - 02:13
Hello, welcome to excelchat.
User
25/06/2018 - 02:13
I want to get a Pop-up when the rating is changed
User
25/06/2018 - 02:14
Hope you got my issue?
Excelchat Expert
25/06/2018 - 02:15
I'm sorry, I'm a bit confused. In the description you have mentioned that you want a message when rating cross 3, now you are saying the message should be poped up when rating changes?
User
25/06/2018 - 02:15
I would like the pop-up pls
User
25/06/2018 - 02:16
in the requirement, i mentioned as Pop-up
User
25/06/2018 - 02:17
are you there ?
Excelchat Expert
25/06/2018 - 02:17
Yeah I'm here.
Excelchat Expert
25/06/2018 - 02:17
Sorry for the delay.
Excelchat Expert
25/06/2018 - 02:17
I got the pop up part.
User
25/06/2018 - 02:17
no issues :)
Excelchat Expert
25/06/2018 - 02:17
What confuses me the above 3/ change part.
User
25/06/2018 - 02:18
its very simple, when the value of a cell changes
User
25/06/2018 - 02:18
i.e. beyond 3
User
25/06/2018 - 02:18
i need to get a pop-up
User
25/06/2018 - 02:18
i think a small macro
User
25/06/2018 - 02:18
i don't know about macros
Excelchat Expert
25/06/2018 - 02:18
I'm sorry the tow are very different things.
Excelchat Expert
25/06/2018 - 02:18
And for the record, we don't support macros in Got It pro.
Excelchat Expert
25/06/2018 - 02:19
I would write a data validation rule to show pop up.
User
25/06/2018 - 02:19
that works for me
Excelchat Expert
25/06/2018 - 02:19
But I have only claimed the problem by reading the description that you want to see a pop up when a value goes above 3.
User
25/06/2018 - 02:20
how-ever that you as an exepert suggest, I just need a pop-up when the value goes beyond 3
Excelchat Expert
25/06/2018 - 02:20
Value goes above 3 and values change are very different.
User
25/06/2018 - 02:20
value goes above
Excelchat Expert
25/06/2018 - 02:20
Okay.
Excelchat Expert
25/06/2018 - 02:20
Understood.
User
25/06/2018 - 02:20
thank you
User
25/06/2018 - 02:20
pls understand, the data is streemed via a different system
Excelchat Expert
25/06/2018 - 02:21
I'm sorry?
User
25/06/2018 - 02:21
i mean, the raing column, these values are coming from other systems
Excelchat Expert
25/06/2018 - 02:21
Are you talking about web integration with excel?
User
25/06/2018 - 02:21
no no
Excelchat Expert
25/06/2018 - 02:21
Then?
User
25/06/2018 - 02:22
for now, lets just get the pop-pu when data goes over 3
User
25/06/2018 - 02:25
hi
Excelchat Expert
25/06/2018 - 02:25
Yeah, I'm here.
Excelchat Expert
25/06/2018 - 02:26
Please give me some time.
User
25/06/2018 - 02:26
sure, I'll be back in 5 mins
User
25/06/2018 - 02:26
ok?
Excelchat Expert
25/06/2018 - 02:26
The session will end in 6 minutes if you don't manually extend the timer.
Excelchat Expert
25/06/2018 - 02:27
I think I need more time than that.
Excelchat Expert
25/06/2018 - 02:27
But I'm trying my best to finish it faster.
User
25/06/2018 - 02:31
I am back
Excelchat Expert
25/06/2018 - 02:31
Thank you, I'm done too.
Excelchat Expert
25/06/2018 - 02:32
[Uploaded an Excel file]
Excelchat Expert
25/06/2018 - 02:32
Please check the file.
Excelchat Expert
25/06/2018 - 02:32
You will get an error message if a value goes above 3 in column B.
User
25/06/2018 - 02:32
how do I check
User
25/06/2018 - 02:32
its not coming
Excelchat Expert
25/06/2018 - 02:32
Input a number above 3 in column B or change an existing value above 3.
Excelchat Expert
25/06/2018 - 02:33
Please check again.
User
25/06/2018 - 02:33
4
User
25/06/2018 - 02:34
nope, its not working
Excelchat Expert
25/06/2018 - 02:34
Are you checking the online file?
User
25/06/2018 - 02:34
both
User
25/06/2018 - 02:34
no where its working
Excelchat Expert
25/06/2018 - 02:35
[Uploaded an Excel file]
Excelchat Expert
25/06/2018 - 02:35
check again this file please.
User
25/06/2018 - 02:36
this is wokring
User
25/06/2018 - 02:36
coud you explain, how did you do this ?
Excelchat Expert
25/06/2018 - 02:36
I'm glad to hear.
Excelchat Expert
25/06/2018 - 02:36
Go to data validation
User
25/06/2018 - 02:36
ok
Excelchat Expert
25/06/2018 - 02:37
Then from setting, click on the allow box and select whole number.
Excelchat Expert
25/06/2018 - 02:37
Then from Data box, select less than or equal to
Excelchat Expert
25/06/2018 - 02:38
Then in maximum box input 3.
Excelchat Expert
25/06/2018 - 02:38
Let me know when done.
User
25/06/2018 - 02:38
1 sec
User
25/06/2018 - 02:40
how to get the corresponding name in the pop-up
Excelchat Expert
25/06/2018 - 02:40
I would have explained that when you had done performing the above steps.
User
25/06/2018 - 02:40
yes, i got the above points
Excelchat Expert
25/06/2018 - 02:41
If you have done the above, click on the error alerts tab.
Excelchat Expert
25/06/2018 - 02:41
Make sure that "show error alert....." box is ticked.
User
25/06/2018 - 02:42
ok
Excelchat Expert
25/06/2018 - 02:42
Then from style box select Information.
User
25/06/2018 - 02:42
ok
Excelchat Expert
25/06/2018 - 02:42
And lastly In the error message box, type the desired message you want to display.
User
25/06/2018 - 02:43
here, I need the coresponding name
User
25/06/2018 - 02:43
not a static vlue
Excelchat Expert
25/06/2018 - 02:43
I'm sorry to inform you that it is not possible.
User
25/06/2018 - 02:43
ohh
User
25/06/2018 - 02:43
Private Sub Worksheet_Calculate()
Dim mycell As Object
Set mycell = ActiveSheet.Cells(1, 1)
If mycell.Value = "OVER" Then
MsgBox "Cell " & mycell.Address & " crosses OVER"
ElseIf mycell.Value = "UNDER" Then
MsgBox "Cell " & mycell.Address & " crosses UNDER"
End If
End Sub
User
25/06/2018 - 02:43
i saw this VBA
Excelchat Expert
25/06/2018 - 02:43
You need VBA for that.
User
25/06/2018 - 02:43
if you can understand this ?
Excelchat Expert
25/06/2018 - 02:44
Yeah but we don't support VBA
User
25/06/2018 - 02:44
thats all right, but a general check
User
25/06/2018 - 02:44
if you can do it
Excelchat Expert
25/06/2018 - 02:44
I have mentioned earlier that VBA question is out of our service scope and I can't really help you in this.
User
25/06/2018 - 02:44
ok
Excelchat Expert
25/06/2018 - 02:45
I'm really really sorry for the inconvenience but I can't break company rules.
Excelchat Expert
25/06/2018 - 02:45
Doing so would be resulted in termination of my contract.
Excelchat Expert
25/06/2018 - 02:45
I hope you understand the situation.
User
25/06/2018 - 02:45
if you know the VBA
User
25/06/2018 - 02:45
pls contact me : +91-9019752890
User
25/06/2018 - 02:45
thats my no
User
25/06/2018 - 02:46
jay.kaveri@gmail.com
Excelchat Expert
25/06/2018 - 02:46
I'm really sorry, I can't contact you outside either.
Excelchat Expert
25/06/2018 - 02:46
We are already well compensated and I'm very loyal and abide by the rules of Got It.
Excelchat Expert
25/06/2018 - 02:47
I really hope you can respect that.
User
25/06/2018 - 02:47
glad to hear that
Excelchat Expert
25/06/2018 - 02:47
Thank you.
Excelchat Expert
25/06/2018 - 02:48
The session will end in 5 minutes. have a great day!
User
25/06/2018 - 02:48
thank youo
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
