Coba begini
If sheets("sheet2").value = vbnullstring then
Msgbox "data kosong"
End if
On May 27, 2014 1:39 AM, "agungdotco...@yahoo.com [belajar-excel]" <
belajar-excel@yahoogroups.com> 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- > >
