[milis-belajar-excel] Kotak centang diceklis jika teks dalam kolom ditemukan sesuai dengan kotak centang

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[milis-belajar-excel] Kotak centang diceklis jika teks dalam kolom ditemukan sesuai dengan kotak centang

riansutarsa
Assalamualaikum Wr. Wb. be-Exceller para suhu sekalian mohon pencerahan dan solusinya bagaimana menampilkan nilai kotak centang terceklis jika satu kolom (4) ditemukan dengan teks yang sama dengan nama kotak centang.  

sebagai bahan pertimbangan saya lampirkan sample file nya .
Terimakasih banyak.
Wassalamu'alaikum Wr. Wb.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/65d226fa-ddd8-4909-bb90-2bf081f4f858n%40googlegroups.com.

ColListbox-to-Checkbox.xls (326K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

[milis-belajar-excel] Re: Kotak centang diceklis jika teks dalam kolom ditemukan sesuai dengan kotak centang

Agus-2
Assalamu'alaikum warahmatullah.
Sambil menunggu yang lebih bagus,
saya menggunakan banyak kolom bantu.
hanya 4 chekbox paling kiri yang sudah dibuat, jika dibutuhkan  tinggal menambah cekrip yang lainnya.
Wasalamulaikum warahmatullah.
KenangAgus

On Wednesday, 23 December 2020 at 17:53:47 UTC+7 [hidden email] wrote:
Assalamualaikum Wr. Wb. be-Exceller para suhu sekalian mohon pencerahan dan solusinya bagaimana menampilkan nilai kotak centang terceklis jika satu kolom (4) ditemukan dengan teks yang sama dengan nama kotak centang.  

sebagai bahan pertimbangan saya lampirkan sample file nya .
Terimakasih banyak.
Wassalamu'alaikum Wr. Wb.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/03f10296-99cc-4d85-a5ef-8c09a937b5b1n%40googlegroups.com.

Copy of ColListbox-to-Checkbox.xls (344K) Download Attachment
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [milis-belajar-excel] Kotak centang diceklis jika teks dalam kolom ditemukan sesuai dengan kotak centang

Kid
Administrator
In reply to this post by riansutarsa
File terlampir memanfaatkan cells berformula, vba, dan properti milik checkbox.

Regards,
Kid



On Wed, Dec 23, 2020 at 5:53 PM Rian Sutarsa <[hidden email]> wrote:
Assalamualaikum Wr. Wb. be-Exceller para suhu sekalian mohon pencerahan dan solusinya bagaimana menampilkan nilai kotak centang terceklis jika satu kolom (4) ditemukan dengan teks yang sama dengan nama kotak centang.  

sebagai bahan pertimbangan saya lampirkan sample file nya .
Terimakasih banyak.
Wassalamu'alaikum Wr. Wb.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/65d226fa-ddd8-4909-bb90-2bf081f4f858n%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAOiZkPsv5%3DEdm%3DXoNiW4NNgmBMM_jgpvRdGWRiONRC17%2B7y5BQ%40mail.gmail.com.

re-ColListbox-to-Checkbox.xls (320K) Download Attachment