Kayaknya yang diminta kebalikannya pak. Salam, HK
Sent from Samsung Mobile -------- Original message -------- Subject:Re: [belajar-excel] MsgBox Data Kosong From:"Ferry Setiawan [email protected] [belajar-excel]" <[email protected]> To:[email protected] Cc: Sorry kurang cell nya If sheets("sheet2").range("a1").value = vbnullstring then Msgbox "data kosong" End if On May 27, 2014 4:07 AM, "Ferry Setiawan" <[email protected]> wrote: Coba begini If sheets("sheet2").value = vbnullstring then Msgbox "data kosong" End if On May 27, 2014 1:39 AM, "[email protected] [belajar-excel]" <[email protected]> wrote: Dear All Master.. Semakin Rame aja nih Groupnya... Mau Tanya nih bagaimana cara membuat Msgbox jika disheet 2 Range A1 ada nilai/datanya maka muncul pesan error "Maaf data harus kosong" pesan itu muncul disheet 1 Thanks,B'Regards -Agunk-
