How to get a msg box showing a list of data?

dikken20

Board Regular
Joined
Feb 25, 2009
Messages
130
Office Version
  1. 2010
Platform
  1. Windows
Hello,

Facts:
1. Sheet contain 20 columns and 600 rows of data.
2. Data is changed dynamically every 1 min using a third party CSV.
3. For illustration purposes only, attached a screenshot of a mini-table so I could explain what needed based on that idea (I hope I attached the image correctly) :



ktt2Gz
https://ibb.co/ktt2Gz
iJDNie


So basically I would need a msg box made of the next fields: Name Old New Change ... BUT I need that as a sorted list of only part of the rows based on the next requirements:
1. The list going to be sorted based on the highest value of the "Change" field.
2. "Change" needs to be above a given percentage.
3. "New" needs to be above a given value.
4. "Old" needs to be a above a given value to prevent a DIV error (red in the attached) and too high results (in yellow)

Example:
#2 Change needs to be >=10%
#3 New needs to be >= 20
#4 Old needs to be >= 5

Msg box will show the next list:

DDD 11 (old) 14 (new) 27.3% (Change)
GGG 188 (old) 233 (new) 23.9% (change)
HHH 467 (old) 532 (new) 13.9% (change)
III 1800 (old) 2011 (new) 11.7% (change)

Notice: This UDF (user defined function) will need to take the entire data to be tested every 1 minute so the msg box might need to be scrolled down as there're 600 rows.

Please help me, let me know if need some clarification.
Thanks
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,223,889
Messages
6,175,223
Members
452,620
Latest member
dsubash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top