Ok, tanks Pada tanggal 10/01/13, Mr. Kid <[email protected]> menulis: > Hai Heru, > > Biasanya butuh sibuk copas script pengecek nilai status variabel kondisi > event ke seluruh events yang dipakai milik seluruh control. > 1. buat sebuah module > 2. isi dengan deklarasi variabel (diluar prosedur apapun alias setelah > baris option explicit kalau ada) > public bIjinEvent as boolean > 3. disetiap event control userform yang digunakan, imbuhkan : > if not bijinevent then > exit sub > endif > bijinevent=false > 'proses milik Anda untuk event tersebut > bijinevent=true > > Wassalam, > Kid. > > 2013/1/9 Heru Safrudin <[email protected]> > >> ** >> >> >> Dear Master, >> >> Adakah cara untuk menonaktifkan event prosedur pada kontrol di userform ? >> Karena jika saat start semua event berjalan membuat userform tampil >> sangat lambat. >> >> -- >> Regards, >> >> Heru Safrudin >> >> >
-- Terima kasih وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ Heru Safrudin ------------------------------------ --------------------------------------------------------------------- bergabung ke milis (subscribe), kirim mail kosong ke: [email protected] posting ke milis, kirimkan ke: [email protected] berkunjung ke web milis http://tech.groups.yahoo.com/group/belajar-excel/messages melihat file archive / mendownload lampiran http://www.mail-archive.com/[email protected]/ atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/ menghubungi moderators & owners: [email protected] keluar dari membership milis (UnSubscribe): kirim mail kosong ke [email protected] ---------------------------------------------------------------------Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/belajar-excel/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/belajar-excel/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
