Dialogue Box

[JudeMarcus]

Hello Team,
Please refer to the attached sample file. I am looking for a macro which pops up a dialogue box saying" Sorry no data available" when there is no data in the table. And whenever there is any data updated in the table then there shouldn't be any pop up box appearing

Thank You

 

[Marc L]

Hi !

Respecting TEBV rule, something like

If [COUNTA(B6:F19)] = 0 Then MsgBox "No data !"

As a reminder : « The better explanation, the better answer … »
​

 

[JudeMarcus]

Apologies for the inconvenience. Let me rephrase my requirement

1)Data in Sheet 2 is connected with Sheet 1. There will be scenarios where based on the data of Sheet 1, Sheet 2 will be having no values to display

2) Therefore on this instance when there is no values to be displayed in table of sheet 2, then there should be a message box as "NO UNITS"

Have attached the revised sample file

Hope this will suffice

Thank You

 

[Marc L]

So directly edit formula of Sheet2!B6 :

=IF(Sheet1!C6=0,"NO UNIT !",Sheet1!C6) …​

 

[JudeMarcus]

Thank you so much Marc