Dear Rasyid, Contoh lain, menggunakan define name. File terlalu besar, tidak dapat dikompresi dibawah 200kb. SIlahkan download disini : http://db.tt/XxbLBc9 (maaf ya mods..)
Blessings, Fran'z On 5/26/11, Contract Mining Assistant, Asam-Asam <[email protected]> wrote: > Dear teman teman belajar excel, > > Gimana ya menampilkan gambar yang ada yang mana sesuai dengan kode buku > yang dipilih, > Asumsinya gambar sudah tersedia di folder seperti pada cell "H2:H11" > yangmana nama gambar disesuaikan dengan kodebuku. > > jadi begitu kode buku dipilih maka nama gambar yang sesuai dengan kode > buku akan tampil > dan jika tidak ada gambar dengan kode buku yang dipilih maka akan ada > pemberitahuan baik itu message box atau yang lain. > > Terima kasih banyak sebelumnya > > Salam, Rasyid > > @File terlampir > Disclaimer - This message including any attachments and information > contained > herein ("Message" ) may contain privileged information or otherwise is > protected > from disclosure. Any unauthorized use of this Message by any person may > lead to > legal consequences. If you receive this Message in error, or if the > recipient > of this Message is not the intended recipient or the employee or agent > authorized > for delivering this Message to the intended recipient you are hereby > notified that > any disclosure, dissemination, distribution or copying of this Message or > let or > cause this Message to be disclosed,disseminated, distributed, or copied is > strictly > prohibited, and please notify the sender by return message and immediately > delete > this Message from your system. Incoming and outgoing communications > using this > electronic mail may be monitored by PT Arutmin Indonesia,as permitted by > applicable > law and regulations. Unless it is made by the authorized person,any views > expressed > in this Message are those of the individual sender and may not necessarily > reflect > the views of PT Arutmin Indonesia. > You should check attachments for viruses and defects before opening or using > them. > We are not liable to recover any injuries caused by virused or defected > attachments. > >
