Home > Software engineering >  EXCEL pop-up
EXCEL pop-up

Time:09-21

Consult everybody: an EXCEL file has a lot of changes in the data (stock price), I want to be a popup tooltip when data in less than a certain price, there may be multiple data set will be lower than the price, how to open the file at the same time show all below setting prices after data?

CodePudding user response:

Your "many" is too vague,
If is to use "message box" tip, it is limited, the number of text should probably in 1024 characters (including not visible characters, such as carriage return, newline, etc.);
If use UserForm, you can on it on the table control, list box control, etc., so that we can show "more project,"

Don't know what you "a lot of data to show what is the point!
If I meet this kind of situation, it is commonly show a dozen, 20, and presented a total of how many items such as "excessive",

CodePudding user response:

In the real world, in addition to the time and space could be infinite, any other things are limited,

CodePudding user response:

Don't see the wizards
  •  Tags:  
  • VBA
  • Related