[belajar-excel] Digest Number 4210

Milis Belajar Microsoft Excel Group

2 Messages

Digest #4210

1a

Image (JPEG) di dalam UserForm yang link ke field tertentu by "hendrik karnadi" hendrikkarnadi

1b

Fw: [belajar-excel] Image (JPEG) di dalam UserForm yang link ke fiel by "hendrik karnadi" hendrikkarnadi

Messages

1a

Image (JPEG) di dalam UserForm yang link ke field tertentu

Tue Jun 13, 2017 12:11 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Selamat siang Be-Excelers,
Saya sedang mengutak atik file terlampir, warisan dari mbak CTV (alm.) mengenai input dengan menggunakan UserForm.
Di dalam contoh terlampir, saya ingin menampilkan image (JPEG) dalam Input Form tsb yang link ke field Part. Jadi jika Part yang diisi ada dalam file gambar (satu folder dengan File Excel ybs. atau dalam folder tersendiri)  maka gambar dari part tsb. akan tampak pada field image yang ada dalam UserForm.
Bagaimana caranya, apakah cukup ditambahkan di property image tsb. atau ditambahkan perintah LoadPicture ?
Terima kasih.
Salam,HK

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Fw: [belajar-excel] Image (JPEG) di dalam UserForm yang link ke fiel

Tue Jun 13, 2017 3:12 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Ini even yang saya tambahakan pada ImgPart dan ketika diklik ada pesan:Sub or Function not defined

Private Sub ImgPart_Click()   Dim pfName As String   pfName = ThisWorkbook.Path & "\Part\" & TbPart.Value   ImgPart.Picture = LoadPicture(IIf(TbPart = "", "", pfName))End Sub

----- Forwarded Message -----
From: "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Sent: Tuesday, 13 June 2017, 14:11
Subject: [belajar-excel] Image (JPEG) di dalam UserForm yang link ke field tertentu [3 Attachments]

  Selamat siang Be-Excelers,
Saya sedang mengutak atik file terlampir, warisan dari mbak CTV (alm.) mengenai input dengan menggunakan UserForm.
Di dalam contoh terlampir, saya ingin menampilkan image (JPEG) dalam Input Form tsb yang link ke field Part. Jadi jika Part yang diisi ada dalam file gambar (satu folder dengan File Excel ybs. atau dalam folder tersendiri)  maka gambar dari part tsb. akan tampak pada field image yang ada dalam UserForm.
Bagaimana caranya, apakah cukup ditambahkan di property image tsb. atau ditambahkan perintah LoadPicture ?
Terima kasih.
Salam,HK #yiv1640218869 #yiv1640218869 -- #yiv1640218869ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1640218869 #yiv1640218869ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1640218869 #yiv1640218869ygrp-mkp #yiv1640218869hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1640218869 #yiv1640218869ygrp-mkp #yiv1640218869ads {margin-bottom:10px;}#yiv1640218869 #yiv1640218869ygrp-mkp .yiv1640218869ad {padding:0 0;}#yiv1640218869 #yiv1640218869ygrp-mkp .yiv1640218869ad p {margin:0;}#yiv1640218869 #yiv1640218869ygrp-mkp .yiv1640218869ad a {color:#0000ff;text-decoration:none;}#yiv1640218869 #yiv1640218869ygrp-sponsor #yiv1640218869ygrp-lc {font-family:Arial;}#yiv1640218869 #yiv1640218869ygrp-sponsor #yiv1640218869ygrp-lc #yiv1640218869hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1640218869 #yiv1640218869ygrp-sponsor #yiv1640218869ygrp-lc .yiv1640218869ad {margin-bottom:10px;padding:0 0;}#yiv1640218869 #yiv1640218869actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1640218869 #yiv1640218869activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1640218869 #yiv1640218869activity span {font-weight:700;}#yiv1640218869 #yiv1640218869activity span:first-child {text-transform:uppercase;}#yiv1640218869 #yiv1640218869activity span a {color:#5085b6;text-decoration:none;}#yiv1640218869 #yiv1640218869activity span span {color:#ff7900;}#yiv1640218869 #yiv1640218869activity span .yiv1640218869underline {text-decoration:underline;}#yiv1640218869 .yiv1640218869attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1640218869 .yiv1640218869attach div a {text-decoration:none;}#yiv1640218869 .yiv1640218869attach img {border:none;padding-right:5px;}#yiv1640218869 .yiv1640218869attach label {display:block;margin-bottom:5px;}#yiv1640218869 .yiv1640218869attach label a {text-decoration:none;}#yiv1640218869 blockquote {margin:0 0 0 4px;}#yiv1640218869 .yiv1640218869bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1640218869 .yiv1640218869bold a {text-decoration:none;}#yiv1640218869 dd.yiv1640218869last p a {font-family:Verdana;font-weight:700;}#yiv1640218869 dd.yiv1640218869last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1640218869 dd.yiv1640218869last p span.yiv1640218869yshortcuts {margin-right:0;}#yiv1640218869 div.yiv1640218869attach-table div div a {text-decoration:none;}#yiv1640218869 div.yiv1640218869attach-table {width:400px;}#yiv1640218869 div.yiv1640218869file-title a, #yiv1640218869 div.yiv1640218869file-title a:active, #yiv1640218869 div.yiv1640218869file-title a:hover, #yiv1640218869 div.yiv1640218869file-title a:visited {text-decoration:none;}#yiv1640218869 div.yiv1640218869photo-title a, #yiv1640218869 div.yiv1640218869photo-title a:active, #yiv1640218869 div.yiv1640218869photo-title a:hover, #yiv1640218869 div.yiv1640218869photo-title a:visited {text-decoration:none;}#yiv1640218869 div#yiv1640218869ygrp-mlmsg #yiv1640218869ygrp-msg p a span.yiv1640218869yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1640218869 .yiv1640218869green {color:#628c2a;}#yiv1640218869 .yiv1640218869MsoNormal {margin:0 0 0 0;}#yiv1640218869 o {font-size:0;}#yiv1640218869 #yiv1640218869photos div {float:left;width:72px;}#yiv1640218869 #yiv1640218869photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1640218869 #yiv1640218869photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1640218869 #yiv1640218869reco-category {font-size:77%;}#yiv1640218869 #yiv1640218869reco-desc {font-size:77%;}#yiv1640218869 .yiv1640218869replbq {margin:4px;}#yiv1640218869 #yiv1640218869ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1640218869 #yiv1640218869ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1640218869 #yiv1640218869ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1640218869 #yiv1640218869ygrp-mlmsg select, #yiv1640218869 input, #yiv1640218869 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1640218869 #yiv1640218869ygrp-mlmsg pre, #yiv1640218869 code {font:115% monospace;}#yiv1640218869 #yiv1640218869ygrp-mlmsg * {line-height:1.22em;}#yiv1640218869 #yiv1640218869ygrp-mlmsg #yiv1640218869logo {padding-bottom:10px;}#yiv1640218869 #yiv1640218869ygrp-msg p a {font-family:Verdana;}#yiv1640218869 #yiv1640218869ygrp-msg p#yiv1640218869attach-count span {color:#1E66AE;font-weight:700;}#yiv1640218869 #yiv1640218869ygrp-reco #yiv1640218869reco-head {color:#ff7900;font-weight:700;}#yiv1640218869 #yiv1640218869ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1640218869 #yiv1640218869ygrp-sponsor #yiv1640218869ov li a {font-size:130%;text-decoration:none;}#yiv1640218869 #yiv1640218869ygrp-sponsor #yiv1640218869ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1640218869 #yiv1640218869ygrp-sponsor #yiv1640218869ov ul {margin:0;padding:0 0 0 8px;}#yiv1640218869 #yiv1640218869ygrp-text {font-family:Georgia;}#yiv1640218869 #yiv1640218869ygrp-text p {margin:0 0 1em 0;}#yiv1640218869 #yiv1640218869ygrp-text tt {font-size:120%;}#yiv1640218869 #yiv1640218869ygrp-vital ul li:last-child {border-right:none !important;}#yiv1640218869

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use