[FAQ000054]I want to display the value of any cell in a pop-up message

Q

I want to display the value of any cell in the message displayed by the action "Pop-up the following message".

"Registration completed.

"=A1"cases"

Can something like the above be written into an action and then have it appear as

"Registration completed.

100 cases"

in a pop-up message?

A

The "Pop up the following message" action can be an expression as well as a message string.

The formula to be specified can be thought of as the same as the one specified for a cell, so you can use your knowledge of Excel.

For example, if you want to display the contents of the A1 cell in the B2 cell in Excel, you can specify "=A1" in the B2 cell and write '=A1 & "cases"' when putting "cases" after the value, and the same applies to CELF.

In addition, if you want to insert a new line in the middle of a string in the CELF pop-up, just insert a new line in the middle of the string and it will be displayed as it should be.

Therefore, if you want to display the result as you requested, the expression to specify is as follows.

'="Registration completed.

" & A1 & "cases"'