Bls: [belajar-excel] Userform untuk multiuser

Thu, 03 Mar 2016 09:18:07 -0800 

Coba di buka2 lagi file2 sebelumnya di milis ini, ada banyak contoh seperti apa 
yang anda inginkan.

TerimaKasih.

Pada Kam, 3/3/16, [email protected] [belajar-excel] 
<[email protected]> menulis:

 Judul: [belajar-excel] Userform untuk multiuser [1 Attachment]
 Kepada: [email protected]
 Tanggal: Kamis, 3 Maret, 2016, 7:38 PM
 
 
  
 
 
 
   
 
 
     
       
       
       Saya awam tentang ms excel tapi saya ingin
 memasukan nilai siswa dengan menggunakan userform excel, dan
 input data nilai tersebut dilakukan oleh beberapa orang
 dengan pc yang berbeda (Workbook di sharing) pada waktu
 bersamaan, bagaimana kode macro ketika tombol Add diKlik,
 mohon bantuan dan pejelasannya.
 
 Atas penjelasanannya saya ucapkan terimakasih
 banyak.
 
 contoh file ada di
 lampiran
 
 
 
     
      
 
     
     
 
 
 
 #yiv1791740352 #yiv1791740352 --
   #yiv1791740352ygrp-mkp {
 border:1px solid #d8d8d8;font-family:Arial;margin:10px
 0;padding:0 10px;}
 
 #yiv1791740352 #yiv1791740352ygrp-mkp hr {
 border:1px solid #d8d8d8;}
 
 #yiv1791740352 #yiv1791740352ygrp-mkp #yiv1791740352hd {
 color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
 0;}
 
 #yiv1791740352 #yiv1791740352ygrp-mkp #yiv1791740352ads {
 margin-bottom:10px;}
 
 #yiv1791740352 #yiv1791740352ygrp-mkp .yiv1791740352ad {
 padding:0 0;}
 
 #yiv1791740352 #yiv1791740352ygrp-mkp .yiv1791740352ad p {
 margin:0;}
 
 #yiv1791740352 #yiv1791740352ygrp-mkp .yiv1791740352ad a {
 color:#0000ff;text-decoration:none;}
 #yiv1791740352 #yiv1791740352ygrp-sponsor
 #yiv1791740352ygrp-lc {
 font-family:Arial;}
 
 #yiv1791740352 #yiv1791740352ygrp-sponsor
 #yiv1791740352ygrp-lc #yiv1791740352hd {
 margin:10px
 0px;font-weight:700;font-size:78%;line-height:122%;}
 
 #yiv1791740352 #yiv1791740352ygrp-sponsor
 #yiv1791740352ygrp-lc .yiv1791740352ad {
 margin-bottom:10px;padding:0 0;}
 
 #yiv1791740352 #yiv1791740352actions {
 font-family:Verdana;font-size:11px;padding:10px 0;}
 
 #yiv1791740352 #yiv1791740352activity {
 
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
 
 #yiv1791740352 #yiv1791740352activity span {
 font-weight:700;}
 
 #yiv1791740352 #yiv1791740352activity span:first-child {
 text-transform:uppercase;}
 
 #yiv1791740352 #yiv1791740352activity span a {
 color:#5085b6;text-decoration:none;}
 
 #yiv1791740352 #yiv1791740352activity span span {
 color:#ff7900;}
 
 #yiv1791740352 #yiv1791740352activity span
 .yiv1791740352underline {
 text-decoration:underline;}
 
 #yiv1791740352 .yiv1791740352attach {
 clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
 0;width:400px;}
 
 #yiv1791740352 .yiv1791740352attach div a {
 text-decoration:none;}
 
 #yiv1791740352 .yiv1791740352attach img {
 border:none;padding-right:5px;}
 
 #yiv1791740352 .yiv1791740352attach label {
 display:block;margin-bottom:5px;}
 
 #yiv1791740352 .yiv1791740352attach label a {
 text-decoration:none;}
 
 #yiv1791740352 blockquote {
 margin:0 0 0 4px;}
 
 #yiv1791740352 .yiv1791740352bold {
 font-family:Arial;font-size:13px;font-weight:700;}
 
 #yiv1791740352 .yiv1791740352bold a {
 text-decoration:none;}
 
 #yiv1791740352 dd.yiv1791740352last p a {
 font-family:Verdana;font-weight:700;}
 
 #yiv1791740352 dd.yiv1791740352last p span {
 margin-right:10px;font-family:Verdana;font-weight:700;}
 
 #yiv1791740352 dd.yiv1791740352last p
 span.yiv1791740352yshortcuts {
 margin-right:0;}
 
 #yiv1791740352 div.yiv1791740352attach-table div div a {
 text-decoration:none;}
 
 #yiv1791740352 div.yiv1791740352attach-table {
 width:400px;}
 
 #yiv1791740352 div.yiv1791740352file-title a, #yiv1791740352
 div.yiv1791740352file-title a:active, #yiv1791740352
 div.yiv1791740352file-title a:hover, #yiv1791740352
 div.yiv1791740352file-title a:visited {
 text-decoration:none;}
 
 #yiv1791740352 div.yiv1791740352photo-title a,
 #yiv1791740352 div.yiv1791740352photo-title a:active,
 #yiv1791740352 div.yiv1791740352photo-title a:hover,
 #yiv1791740352 div.yiv1791740352photo-title a:visited {
 text-decoration:none;}
 
 #yiv1791740352 div#yiv1791740352ygrp-mlmsg
 #yiv1791740352ygrp-msg p a span.yiv1791740352yshortcuts {
 font-family:Verdana;font-size:10px;font-weight:normal;}
 
 #yiv1791740352 .yiv1791740352green {
 color:#628c2a;}
 
 #yiv1791740352 .yiv1791740352MsoNormal {
 margin:0 0 0 0;}
 
 #yiv1791740352 o {
 font-size:0;}
 
 #yiv1791740352 #yiv1791740352photos div {
 float:left;width:72px;}
 
 #yiv1791740352 #yiv1791740352photos div div {
 border:1px solid
 #666666;height:62px;overflow:hidden;width:62px;}
 
 #yiv1791740352 #yiv1791740352photos div label {
 
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
 
 #yiv1791740352 #yiv1791740352reco-category {
 font-size:77%;}
 
 #yiv1791740352 #yiv1791740352reco-desc {
 font-size:77%;}
 
 #yiv1791740352 .yiv1791740352replbq {
 margin:4px;}
 
 #yiv1791740352 #yiv1791740352ygrp-actbar div a:first-child {
 margin-right:2px;padding-right:5px;}
 
 #yiv1791740352 #yiv1791740352ygrp-mlmsg {
 font-size:13px;font-family:Arial, helvetica, clean,
 sans-serif;}
 
 #yiv1791740352 #yiv1791740352ygrp-mlmsg table {
 font-size:inherit;font:100%;}
 
 #yiv1791740352 #yiv1791740352ygrp-mlmsg select,
 #yiv1791740352 input, #yiv1791740352 textarea {
 font:99% Arial, Helvetica, clean, sans-serif;}
 
 #yiv1791740352 #yiv1791740352ygrp-mlmsg pre, #yiv1791740352
 code {
 font:115% monospace;}
 
 #yiv1791740352 #yiv1791740352ygrp-mlmsg * {
 line-height:1.22em;}
 
 #yiv1791740352 #yiv1791740352ygrp-mlmsg #yiv1791740352logo {
 padding-bottom:10px;}
 
 
 #yiv1791740352 #yiv1791740352ygrp-msg p a {
 font-family:Verdana;}
 
 #yiv1791740352 #yiv1791740352ygrp-msg
 p#yiv1791740352attach-count span {
 color:#1E66AE;font-weight:700;}
 
 #yiv1791740352 #yiv1791740352ygrp-reco
 #yiv1791740352reco-head {
 color:#ff7900;font-weight:700;}
 
 #yiv1791740352 #yiv1791740352ygrp-reco {
 margin-bottom:20px;padding:0px;}
 
 #yiv1791740352 #yiv1791740352ygrp-sponsor #yiv1791740352ov
 li a {
 font-size:130%;text-decoration:none;}
 
 #yiv1791740352 #yiv1791740352ygrp-sponsor #yiv1791740352ov
 li {
 font-size:77%;list-style-type:square;padding:6px 0;}
 
 #yiv1791740352 #yiv1791740352ygrp-sponsor #yiv1791740352ov
 ul {
 margin:0;padding:0 0 0 8px;}
 
 #yiv1791740352 #yiv1791740352ygrp-text {
 font-family:Georgia;}
 
 #yiv1791740352 #yiv1791740352ygrp-text p {
 margin:0 0 1em 0;}
 
 #yiv1791740352 #yiv1791740352ygrp-text tt {
 font-size:120%;}
 
 #yiv1791740352 #yiv1791740352ygrp-vital ul li:last-child {
 border-right:none !important;
 }
 #yiv1791740352

Kirim email ke