Dear Mr. Kid,Keren.... Excel memang powerfull.....Terima kasih atas
bantuannya......... Odhy.
On Friday, January 27, 2017 7:41 AM, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> wrote:
Hai Odhyz,
File terlampir contoh tanpa userform.
Meski tanpa userform, baris-baris kode yang ada bisa diterapkan pada image
control yang ada dalam suatu userform.
Di dalam baris-baris kode dalam file terlampir juga diberi keterangan dan
beberapa tambahan yang masih non aktif seperti pengaturan ketersediaan default
image file ketika data yang terpilih belum memiliki image file yang sesuai
inputan.
Silakan dikembangkan secara santun.
Regards,
Kid
2017-01-26 20:38 GMT+07:00 Odhyz [email protected] [belajar-excel]
<[email protected]>:
Dear Master,Terima kasih atas bantuannya... Codingya sdh running....
Dikirim dari iPhone saya
Pada 24 Jan 2017, pukul 09.14, 'Heru Safrudin' fcprocessing.bisikediri@bisi.
co.id [belajar-excel] <[email protected] > menulis:
Coba kode dikoreksi seperti berikut : Private Sub
Worksheet_SelectionChange( ByVal Target As Range)Dim MyPath As StringDim Mypic
As String MyPath = ThisWorkbook.Path & "\" &Target.Value & ".jpg" ‘Ini
sudah mendefinisikan gambarnya MsgBox MyPath If Intersect(Target,
Range("a1:a5")) Is NothingThen Exit Sub Mypic = Target.Value & ".jpg"
‘Jadi inisudah tidak diperlukan lagi UserForm1.Image1.Picture =
LoadPicture(MyPath) ‘Coba dengankode ini UserForm1.Show End Sub
<image002.gif><image004.png>
From:[email protected] [mailto:belajar-excel@ yahoogroups.com]
Sent: 19 Januari 2017 17:54
To: [email protected]
Subject: [belajar-excel] Membuat Form Popup gambar [1 Attachment] Dear Para
Master,Mohon bantuannya, saya membuat Menu Popup namun belum berhasil(attach),
pada saat saya klik tiap cell yang berisi item code akan muncul menupopup
gambar sesui dengan item code pada tiap2 cell seperti terlampir. Atas
bantuannya saya ucapkan banyak terima kasih.
#yiv7534436728 #yiv7534436728 -- #yiv7534436728ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7534436728
#yiv7534436728ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7534436728
#yiv7534436728ygrp-mkp #yiv7534436728hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7534436728 #yiv7534436728ygrp-mkp #yiv7534436728ads
{margin-bottom:10px;}#yiv7534436728 #yiv7534436728ygrp-mkp .yiv7534436728ad
{padding:0 0;}#yiv7534436728 #yiv7534436728ygrp-mkp .yiv7534436728ad p
{margin:0;}#yiv7534436728 #yiv7534436728ygrp-mkp .yiv7534436728ad a
{color:#0000ff;text-decoration:none;}#yiv7534436728 #yiv7534436728ygrp-sponsor
#yiv7534436728ygrp-lc {font-family:Arial;}#yiv7534436728
#yiv7534436728ygrp-sponsor #yiv7534436728ygrp-lc #yiv7534436728hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7534436728
#yiv7534436728ygrp-sponsor #yiv7534436728ygrp-lc .yiv7534436728ad
{margin-bottom:10px;padding:0 0;}#yiv7534436728 #yiv7534436728actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7534436728
#yiv7534436728activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7534436728
#yiv7534436728activity span {font-weight:700;}#yiv7534436728
#yiv7534436728activity span:first-child
{text-transform:uppercase;}#yiv7534436728 #yiv7534436728activity span a
{color:#5085b6;text-decoration:none;}#yiv7534436728 #yiv7534436728activity span
span {color:#ff7900;}#yiv7534436728 #yiv7534436728activity span
.yiv7534436728underline {text-decoration:underline;}#yiv7534436728
.yiv7534436728attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7534436728 .yiv7534436728attach div a
{text-decoration:none;}#yiv7534436728 .yiv7534436728attach img
{border:none;padding-right:5px;}#yiv7534436728 .yiv7534436728attach label
{display:block;margin-bottom:5px;}#yiv7534436728 .yiv7534436728attach label a
{text-decoration:none;}#yiv7534436728 blockquote {margin:0 0 0
4px;}#yiv7534436728 .yiv7534436728bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7534436728
.yiv7534436728bold a {text-decoration:none;}#yiv7534436728 dd.yiv7534436728last
p a {font-family:Verdana;font-weight:700;}#yiv7534436728 dd.yiv7534436728last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7534436728
dd.yiv7534436728last p span.yiv7534436728yshortcuts
{margin-right:0;}#yiv7534436728 div.yiv7534436728attach-table div div a
{text-decoration:none;}#yiv7534436728 div.yiv7534436728attach-table
{width:400px;}#yiv7534436728 div.yiv7534436728file-title a, #yiv7534436728
div.yiv7534436728file-title a:active, #yiv7534436728
div.yiv7534436728file-title a:hover, #yiv7534436728 div.yiv7534436728file-title
a:visited {text-decoration:none;}#yiv7534436728 div.yiv7534436728photo-title a,
#yiv7534436728 div.yiv7534436728photo-title a:active, #yiv7534436728
div.yiv7534436728photo-title a:hover, #yiv7534436728
div.yiv7534436728photo-title a:visited {text-decoration:none;}#yiv7534436728
div#yiv7534436728ygrp-mlmsg #yiv7534436728ygrp-msg p a
span.yiv7534436728yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7534436728
.yiv7534436728green {color:#628c2a;}#yiv7534436728 .yiv7534436728MsoNormal
{margin:0 0 0 0;}#yiv7534436728 o {font-size:0;}#yiv7534436728
#yiv7534436728photos div {float:left;width:72px;}#yiv7534436728
#yiv7534436728photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7534436728
#yiv7534436728photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7534436728
#yiv7534436728reco-category {font-size:77%;}#yiv7534436728
#yiv7534436728reco-desc {font-size:77%;}#yiv7534436728 .yiv7534436728replbq
{margin:4px;}#yiv7534436728 #yiv7534436728ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7534436728 #yiv7534436728ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7534436728
#yiv7534436728ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7534436728
#yiv7534436728ygrp-mlmsg select, #yiv7534436728 input, #yiv7534436728 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7534436728
#yiv7534436728ygrp-mlmsg pre, #yiv7534436728 code {font:115%
monospace;}#yiv7534436728 #yiv7534436728ygrp-mlmsg *
{line-height:1.22em;}#yiv7534436728 #yiv7534436728ygrp-mlmsg #yiv7534436728logo
{padding-bottom:10px;}#yiv7534436728 #yiv7534436728ygrp-msg p a
{font-family:Verdana;}#yiv7534436728 #yiv7534436728ygrp-msg
p#yiv7534436728attach-count span {color:#1E66AE;font-weight:700;}#yiv7534436728
#yiv7534436728ygrp-reco #yiv7534436728reco-head
{color:#ff7900;font-weight:700;}#yiv7534436728 #yiv7534436728ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7534436728 #yiv7534436728ygrp-sponsor
#yiv7534436728ov li a {font-size:130%;text-decoration:none;}#yiv7534436728
#yiv7534436728ygrp-sponsor #yiv7534436728ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7534436728
#yiv7534436728ygrp-sponsor #yiv7534436728ov ul {margin:0;padding:0 0 0
8px;}#yiv7534436728 #yiv7534436728ygrp-text
{font-family:Georgia;}#yiv7534436728 #yiv7534436728ygrp-text p {margin:0 0 1em
0;}#yiv7534436728 #yiv7534436728ygrp-text tt {font-size:120%;}#yiv7534436728
#yiv7534436728ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7534436728
