Excel sheet Pop up required

[Techtrend]

Hello Team


Is it possible to create the Pop Up in excel,
The sample sample sheet is attached for your reference

In the attached sheet the Q Col is the price which keeps getting updated in the live market and we need it to compare with M and N COl,

if the Q price is in between the M and N = Nothing
if the Q price is in higher or lower in the M and N = POP UP required with the related price in Of M and N Col.

Hope this is clear,
Let me know if any more clarifications required.

Regards
Narendra

 

[Hui]

What about using Conditional Formatting (CF) instead?

First clear the current background colors from Q2:Q11

Select Q2:Q11
Conditional Formatting
New Rule
Use a Formula
=if(Q2<Min(M2:N2),True,false)
Add a Green Format

Add a 2nd CF
Select Q2:Q11
Conditional Formatting
New Rule
Use a Formula
=if(Q2>Max(M2:N2),True,false)
Add a Red Format

see attached file:

 

[Hui]

if you really want a popup you can add teh following code to the Worksheet Module for Sheet 1

Private Sub Worksheet_Change(ByVal Target As Range)
Dim Msg As String

If Intersect(Target, Range("Q2:Q11")) Is Nothing Then Exit Sub

If Target < Cells(Target.Row, 14) Then
  Msg = CStr(Target) + " is less than " + Cells(Target.Row, 14).Text
  Msg = Msg + Chr(13) + "in cell " + Target.Address
  x = MsgBox(Msg, vbOKOnly, "Low target value")
ElseIf Target > Cells(Target.Row, 13) Then
  Msg = CStr(Target) + " is greater than " + Cells(Target.Row, 13).Text
  Msg = Msg + Chr(13) + "in cell " + Target.Address
  x = MsgBox(Msg, vbOKOnly, "High target value")
End If

End Sub

or see attached file:

 

[Techtrend]

Hello

Thanks for the info,
Can you please tell me where should i add this code,
should i create the Macros for the same

Narendra

 

[Hui]

The Conditional Formatting option is self explanatory

The VBA is added to a Worksheet module in VBA
Alt+F11
Find the worksheet and in the explorer window on the left and double click it
Copy the code above onto the worksheet module that opens

Both my examples contained your file ?

 

[Techtrend]

Hello Hui

I am sorry to bother you,
As the Macros are new to new.

Not able to figure out how the pop works,
in the sheet which you have Attached when i chk ALT+F11 i can see the Code
but not sure how to run this.

When the Q COl price is above M or below N need to generate the POP UP.

Thank you so much for your Time
Narendra

 

[Hui]

When you open the file, accept macro's
Then it is automatic
Change a value in any cell in the range Q2:Q11
It pops up

 

[Techtrend]

Hello Hui

Superb It works

Thanks for your Time
Narendra

 

[Techtrend]

Hello Hui

Attached is the live sheet and Simplified the formula,
Cant see the data as it works only on the live market.

The U Col Has BUY and SHORT based on some conditions it gets highlighted.

Need a similar favor as you done before,

Required Pop Up if BUY is Prompted or Short Is prompted in the U COl.

Advance Thanks For your time
Narendra

 

[Hui]

See attached:

 

[Techtrend]

Hello Hui

Works fine,Thank you so much.

Regards
Narendra

 

[Techtrend]

Hello Hui

It works fine offline ,The movement the sheet runs on live market the Pop up doesn't Work,I am not sure what is the issue

Do you have knowledge on PHP so that we can develop an Web Application of the same.

If yes can i have your email ID.

Regards
Narendra

 

[Hui]

You can add a button to make it run on demand
Or incorporate a trigger in your existing code to run it when the update is complete

 

[Techtrend]

Ok Thanks Hui