How to edit multiple data in userform?

xeerrox

New Member
Joined
Jun 1, 2022
Messages
1
Office Version
  1. 2013
Platform
  1. Windows
As you can see from the first picture i have to put a check on the one circled there. The 2nd picture is the excel where if checked it would be numbered 1. Problem is there are 1.2k data for me to check the box and i dont think i can do it one by one. I wanted to just key in the number manually but the excel is protected and i cant unprotect it to make any edit. Are there anyway for me to solve this?

Hwalian Final.xlsm
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCVCWCXCYCZDADBDCDDDEDFDGDHDIDJDKDLDMDNDODPDQDRDSDTDUDVDWDXDYDZEAEBECEDEEEFEGEHEIEJEKELEMENEOEPEQERESETEUEVEWEXEYEZFAFBFCFDFEFFFGFHFIFJFKFLFMFNFOFP
12KOTAKCatatan SemakanPENDAFTARANPEMERIKSAAN AWAL PENYATA AKHIRKOTAKCatatanNama Operator (Charting)RendahMenengahnama Sekolahnama KpdarjahtingkatanPasukan BergerakPra SekolahKKIBPE Skor (0/1/2/3/4)JENIS ROKOK(ROKOK BIASA/ELEKTRONIK/SHISHA/LAIN-LAIN)Status berhenti merokok selepas 6 bulan (Berhenti/Tidak berhenti)Menjalankan BEGINGIGI DESIDUSPEMERIKSAAN (ENGGAN/ TIDAK HADIR) 1-Ada Charting, 2-Tiada ChartingPERMASYARAKATANNAMA PENUH BAPAJUMLAH AHLI KELUARGA ≤ 17 TAHUNJUMLAH AHLI KELUARGA ≥ 18 TAHUNSELESAI 4X SAPUAN DALAM TEMPOH 2 TAHUNKEKAL MBK SELEPAS 4X SAPUANUmur (Bulan) - bayi dibawah 1 tahun sahajaSekolah Masyarakat Rujuk ke PP Klinik/ Pusat Pergigian Sekolah (Statik)Pasukan/ Klinik Pergigian BergerakCeramahPameran
13Status MerokokIntvnsi >=3Intvnsi <3Nombor siriEnrolmenKedatanganJantina (L/P)Umur Keturunan (M/C/I/LL)Status MerokokCleft Lip/Cleft Palate TraumaStatus DenturKebersihan Mulut (A/C/E)GIS Skor (0/1/2/3)Status Gigi DesidusStatus Gigi KekalMulut Bebas Karies (MBK)E ≥ 1 (ada karies awal)Mulut Bebas Gingivitis (MBG)Tidak Perlu Rawatan (SMKP)Tidak Perlu Rawatan (ICDAS)Caries Risk AssessmentFissure SealantPerlu DibuatTelah DibuatAbsesPulpotomiRawatan EndodontikKes Selesai ICDASKes SelesaiRujukJumlah intervensi lanjutan yang disertaiADA QUIT DATE TIADA QUIT DATE Perokok dirujuk kepada guru kaunseling
14Perokok SemasaBekasPasifBukanBaruUlanganEngganTidak HadirTooth Surface Loss (TSL)Tisu LembutTisu KerasKecederaan Gigi AnteriorKariesTelah DicabutTelah DitampalPerlu DicabutJumlah dfxdfx = 0dfx ≤ 2Karies AwalKariesTelah DicabutTelah DitampalPerlu DicabutJumlah DMFXAppendix 3DMFX <= 3DMFX ≤ 1 (SR) DMFX ≤ 2 (SM)X+M = 0Bebas Karies (BK) DMFX = 0Bebas Karies (BK) tetapi E ≥ 1Bil FS Dibuat Pada Tahun LepasBil FS Intact Bagi Tahun SemasaFisur Sealan Sapuan Varnish Fluorida Restorasi Pencegahan (PRR Jenis 1)SMKPTampalanFisur Sealan Sapuan Varnish Fluorida Restorasi Pencegahan (PRR Jenis 1)SMKPTampalanJumlah TampalanTampalan SementaraCabutanPenskaleran
15LelakiPerempuanLelakiPerempuanLelakiPerempuanLelakiPerempuanBerhentiTidak BerhentiBerhentiTidak BerhentiAdaRujukAdaPerluD+FJumlah Faktor Risiko KariesRisiko KariesMURID: Perlu dibuat Fisur Sealan/PRR Type 1 sahaja atau kedua-duanyaAnteriorPosteriorMURID: Telah dibuat Fisur Sealan/PRR Type 1 sahaja atau kedua-duanyaAnteriorPosteriorGigi DesidusGigi Kekal
16MelayuCinaIndiaLain-lainMelayuCinaIndiaLain-lainKelasNamaBil Gigi 'Caries Experience"Class I dan IIClass I SahajaRendahSederhanaTinggiMuridGigi Perlu FSBil. Gigi `failed' FSMuridGigiMuridGigiSewarnaSewarnaAmalgamMuridGigi Telah Dibuat FSMuridGigiMuridGigiSewarnaSewarnaAmalgam
17BSBSdmfxEDMFXResinGICBSBSBSBSBSBSGDGKGDGKGDGKBSBSBSBSBSBSGDGKGDGKGDGK
18BSBSBSBSBSBSBSBSBSBSBSBSBS
19153456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172
20114HEDWARD YONG JUN TAO11L16CINAPEROKOK PASIFA101141555010104001DR CHOO1HWA LIANKP MENTAKAB4PBB101
2112PARALPH CHOI JUN HIN11L13CINABUKAN PEROKOKA00000111111110001DR LUQMAN1HWA LIANKP MENTAKABPERALIHANPBB01
2213PALEONG MING HIN11L13CINABUKAN PEROKOKC31110011111000DR LUQMAN1HWA LIANKP MENTAKABPERALIHANPBB01
Sekolah
 

Attachments

  • 1st.jpg
    1st.jpg
    19.7 KB · Views: 6
  • 2nd.jpg
    2nd.jpg
    23.2 KB · Views: 6

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Forum statistics

Threads
1,215,543
Messages
6,125,423
Members
449,223
Latest member
Narrian

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top