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" <fset2...@gmail.com> wrote:
> 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-
>>
>>
>
