Wah iya kebalik hahaha...
If sheets("sheet2").range("a1"). value <> vbnullstring then
Msgbox "data harus kosong"
End if
On May 27, 2014 10:13 AM, "Hendrik Karnadi
[email protected][belajar-excel]" <
[email protected]> wrote:
>
>
> 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-
>>>
>>>
>
