Message box : show messages with cells from excel

Hi there,

So I have an excel table with two collumns where there are writen some numbers.

I need to write in an messagebox, “The row is” number of the row, “and the value is” cell value.

How can I do this?

Can anyone help me?

Thanks

Also how can I show in a message box only perfect numbers?

Use for each row activity and display the elements using the messagebox.

Thank you! You know how can I write the row and the cell vallue in the msgbox?

Have you used for each row activity?

Hey @Gabriel2,

  1. Use Read Cell activity to retrieve information from Excel. It will return string value as a result.
  2. Use Message Box activity and set result to Text property

Cheers :+1:

Yes, I solved it. Thanks :slight_smile: The next step is to show in the message box only even numbers. Any Ideeas?

@Gabriel2, You can use IF condition to apply additional logic. :slight_smile:

I don’t know what to put in the condition of the if to find the odd numbers

@Gabriel2, You may want to implement something like this:

image

Cheers :+1:

Perfect. It worked Thanks!

Now I need to show a msgbox if a number from a cell , from column A is in a cell form collumn B. Any thougths? Filter Data table?

I made a read range for each collumn and I have two data tables : col1 and col2

Now I need to show a msgbox if any number from the col1 is found in col 2

How can I do this?

I made a read range for each collumn and I have two data tables : col1 and col2

Now I need to show a msgbox if any number from the col1 is found in col 2

How can I do this?

image

If not I need to put a msgb with the message " Does not exist"

Check this workflow and the input file, @Gabriel2
Test.xlsx (9.1 KB) Test_1.xaml (23.6 KB)

2 Likes

I made my modifications and it worked. Thanks!:slight_smile:

Happy Automation :smiley:.

I have another question

So I need to show another msgbox like this:

Col 1: “value first cell” , Col2:“value first cell” Row :“Number Row”

I have variables for each collum in a datatable and used an for each and an if but I don’t know how to make the condition in the if activity and in the message box.
Any ideeas, it will help me alot.

Thanks