Msg Box for cell value being Null

[dineshsachidananda]

I have an excel template, werein Cell ( C23 ) is base on the value entered C ( 9 )

In case if C9 does not reflect a resullt ( NULL ) in C23, i need a message box with a custom message...

[amromerodiaz]

Hello,

Try this:

Use this formula in Cell C23: =IF(C9="","",C9)

and use this code VBA:

Please Login or Register  to view this content.

Regards,

Alvaro

[dineshsachidananda]

Thanks Alvaro for the rep...

I do not want an else.... I just need a messgae for null value

[amromerodiaz]

You are welcome!

In that case, do the following:

Use this formula in Cell C23: =IF(C9="","",C9)

and use this code VBA:

Please Login or Register  to view this content.

You can write whatever you want instead of "The cell is empty".

I hope this can help you!

Alvaro

[dineshsachidananda]

Thanks for the quick response.... Please give me few min and I can share the excel for me to explain better... sorry for the inconvnce

[amromerodiaz]

Ok, No problem!!