Gudaha Microsoft Excel, Kontaroolada Foomka^{(Form Controls)} , waxay faa'iido u leedahay xulashada shayada ku jira liiska xaashida wada hadalka. Xakamaynta Foomku^{(Form Controls)} waxay u fududaysaa isticmaalayaasha inay la falgalaan xogta unugga ee ay sameeyeen. Dhowr foom oo kontorool^{(Control Forms)} ayaa ku dari doona xaashida shaqada; kuwani waa calaamada^(Label) , sanduuqa kooxda , ^(Group)badhanka jeeg-garaynta^{(Checkbox Button)} , badhanka ikhtiyaarka^{(Option Button)} ah, sanduuqa liiska^{(List Box)} , sanduuqa^{(Combo Box)} isku-dhafka ah , rog-rog^{(Scroll Bar)} , iyo badhanka lafdhabarta^{(Spin Button)} .

Noocyada Kontoroolka Foomka

• ^(Label)Summada^(Labels) : Calaamaduhu waxay muujinayaan qoraal sifayn ah sida sawirro, cinwaanno, iyo qoraallo, waxay sidoo kale tilmaamaysaa ujeeddada unugga.
• Sanduuqa Kooxda^{(Group box)} : Waxyaabaha ku dhow dhow waxaa lagu kooxeeyay calaamad ikhtiyaari ah.
• Badhan^(Button) : Xakamayntani^(Control) waxay waddaa makro waxayna qabataa ficil marka isticmaaluhu gujiyo.
• Sax sanduuqa^{(Check Box)} : tani waxay siinaysaa isticmaalaha ikhtiyaarka ah inuu shido oo damiyo qiime tilmaamaya doorashada lidka ku ah. Waxaad dooran kartaa in ka badan hal sanduuq oo sax ah^{(Check Box)} .
• Badhanka Ikhtiyaarka:^{(Options Button: )} Sida sanduuqa jeegga^{(Check Box)} , waxa kale oo ay ku siinaysaa ikhtiyaarka aad ku shidayso oo aad damiso qiime tilmaamaya doorasho lid ku ah. Farqiga kaliya ayaa ah in badhanka ikhtiyaarka^{(Option Button)} ah uu u ogolaado isticmaaluhu inuu doorto hal doorasho oo keliya, oo ka duwan Sanduuqa Hubinta^{(Check Box)} .
• Liisaska Liiska:^{(List Box:)} Waxa uu soo bandhigayaa liiska walxaha qoraalka ah ee isticmaaluhu ka dooran karo.
• Sanduuqa Combo^{(Combo Box)} : Kani waa sanduuq qoraal ah oo leh sanduuq liis ah si loo sameeyo sanduuqa liiska hoos u dhaca. Sanduuqa combo wuxuu u ogolaanayaa isticmaalaha inuu gujiyo fallaadho hoos u dhac si uu u muujiyo liiska.
• Dul-wareejin: Ku dhex ^{(Scroll Bar: )}dhaadhac^(Scroll) qiyam kala duwan adiga oo isticmaalaya furayaasha fallaadha rog-rog ama jiid ama jiid sanduuqa-rog-rogid.
• Button Spin:^{(Spin Button: )} Tani waxay kordhisaa ama yaraynaysaa qiyamka sida tirooyinka, taariikhaha, ama wakhtiga. Si aad u kordhiso qiimaha, guji falaarta sare; si loo dhimo qiimaha dhagsii falaarta hoose.

Abuur oo ku isticmaal Koontaroolada Foomka gudaha Excel

Maqaalkan, waxaynu kaga hadli doonaa mawduucyadan:

1. Sida Loo Helo Koontaroolada Foomka
2. Sida Loo Sameeyo Summada
3. Sida loo sameeyo Button
4. Sida loo sameeyo sanduuq jeeg ah
5. Sida loo sameeyo badhanka ikhtiyaarka ah
6. Sida loo sameeyo Sanduuqa Liiska
7. Sida loo sameeyo sanduuqa Combo
8. Sida loo sameeyo Bar-rogid
9. Sida loo sameeyo batoonka Spin
10. Sida loo sameeyo Sanduuqa Kooxda

1] Sida loo Helo Koontaroolada Foomka

Midig ku dhufo Barta Qalabka caadiga ah^{(Standard Tool Bar)} oo dooro Ribbon la Habeeyay^{(Customized the Ribbon)} . Sanduuqa wada hadalka ayaa soo bixi doona oo loo yaqaan ' Excel Option ' . Dhanka bidix ee sanduuqa wada-hadalka, dhagsii sanduuqa calaamadee ee ku^{(Check Box)} ag yaal horumariyaha^(Developer) , ka dibna OK. Bar Menu,^{(Menu Bar, )} waxaad ku arki doontaa tab horumariyaha .^{(Developer )}

2] Sida loo Sameeyo Summada

Daaqadda Horumariyaha^{(Developer Window)} , dhagsii Qalabka Gelida^{(Insert Tool)} , waxaad arki doontaa liiska foomamka kantaroolka^{(Control Forms)} . Guji Summada^(Label) _ Waxaad arki doontaa calaamad muujinaysa qaabka iskutallaabta; u isticmaal si aad u sawirto calaamadda^(Label) , dabadeed midig-guji oo dooro Tafatirka qoraalka^{(Edit Text)} si aad qoraalkaaga ugu geliso calaamadda^(Label) .

3] Sida loo sameeyo Button

Tag Qalabka^{(Insert Tool)} Gelida ee Kooxda Xakamaynta^{(Controls Group)} . Dooro Badhanka Qalabka^{(Button Tool)} . Waxaad arki doontaa calaamadaynta qaabka iskutallaabta; u jiid si aad u abuurto badhanka. Sanduuqa wada hadalka Macro^{(Assign Macro)} Assign ayaa soo bixi doona. Guji ^(Click) OK _ Waxaad ku arki doontaa badhan^(button) xaashida sare.

4] Sida loo sameeyo sanduuq sax ah

Tag Qalabka Gelida^{(Insert Tool)} oo dooro Qalabka Hubinta^{(Check Box Tool)} . Calaamadaynta qaabka iskutallaabta ayaa soo bixi doonta sawir sanduuqaaga^{(Check Box)} calaamadee . Hadda waxaad haysataa sanduuq jeeg^{(Check Box)} ah . Si aad dib u magacawdo, midig-guji sanduuqa jeegga^{(Check Box)} oo dooro qoraalka^{(Edit text)} wax ka beddel .

5] Sida loo sameeyo badhanka ikhtiyaarka ah

Sanduuqa Gelida^{(Insert Toolbox)} , dooro badhanka ikhtiyaarka^{(Option Button)} ah . Waxaa jiri doona calaamado iskutallaab ah; Qaado curcurka qaabka iskutallaabta ah, oo sawir badhanka ikhtiyaarka^{(Option Button)} ah . Si aad qoraalka u geliso badhanka ikhtiyaarka^{(Option Button)} ah , midig-guji ama laba jeer taabo badhanka oo geli qoraalkaaga ama midig-guji oo dooro Tafatirka qoraalka^{(Edit Text)} .

6] Sida loo sameeyo Liiska Liiska

Tag Qalabka Gelida^{(Insert Tool)} , dooro Liiska Liiska^{(List Box)} ; calaamad iskutallaab ah ayaa ka soo bixi doonta buugga shaqada, oo isticmaal calaamadda qaabka iskutallaabta ah si aad u sawirto Liiska Liiska^{(List Box)} . Si aad xogta u geliso sanduuqa, guji midigta ku dhufo sanduuqa, oo dooro Qaabka Kontoroolka^{(Format Control)} , sanduuqa ^{(Dialog Box)}Xakamaynta^{(Format Control)} Hababka ayaa soo muuqan doona, dhagsii Control , dhagsi galitaanka Range Input^{(Input Range)} , ka dib u gudub unugga aad rabto inaad ku jirto liiska. , ku dhufo oo soo jiid. Kala duwanaanshaha wax gelinta ee la doortay waxa uu ku yaalaa Range Input^{(Input Range )} ee sanduuqa wada-hadalka, hadda guji gelida xidhiidhinta unugga^{(Cell Link)} oo dooro unug meesha aad rabto in la geliyo xidhiidhka unugga .^{(Cell Link)}

Isku xirka unuggu^{(Cell Link)} wuxuu soo bandhigi doonaa xog kasta oo aad gujiso Liiska Liiska^{(List Box)} ; safku wuxuu u muuqan doonaa qiime kasta oo la doortay. Markaa OK . Haddii aad rabto in Liistuku^{(List Box)} uu muujiyo safafka nambar kasta oo aad dooratay gudaha sanduuqa, guji tirada unugyada aad dooratay, guji mid ka mid ah xogta liiska ku jirta oo muuji safka ay xogta ku jirto. Haddii aad rabto in aad muujiso kaliya xogta liiska, isticmaal qaacidadan =INDEX (B2:B7, J2, 0) . B2:B7 waa tirada unugga aad dooratay , J2 waa safkii aad horay u soo bandhigtay. Markaad riixdo geli, waxaad arki doontaa lambarka asalka ah ee liiska marka aad gujiso lambar kasta oo liiska ku jira.

7] Sida loo sameeyo sanduuqa combo

Guji Qalabka Gelida^{(Insert Tool)} , dooro Sanduuqa Combo^{(Combo Box)} . Isticmaal calaamadaynta qaabka iskutallaabta si aad u sawirto sanduuqa Combo^{(Combo Box)} , midig-guji sanduuqa Combo^{(Combo Box)} , dooro Form Controls , Guji Range Input^{(Input Range)} , ka dibna dulmar qolka aad rabto in liiska ku jiro oo hoos u jiid, dhagsii Unugga Isku xidh^{(Cell Link)} oo dooro unug meesha aad rabto in la dhigo Link^{(Cell Link)} -ga unugga . Maqaalkan, waxaanu dul dhignay sanduuqa Combo^{(Combo Box)} ee la sawiray. Markaa OK . Hadda waxaad buuggaaga shaqada ku haysaa sanduuqa Combo Box^{(Combo Box)} oo shaqaynaya.

8] Sida loo sameeyo bar-rogid

Guji Gelida^(Insert) , dooro Scroll Bar ,^{(Scroll Bar)} ku sawir bar- xajinta^{(Scroll Bar)} xaashida shaqada, ka dib midig-guji, dooro Form Controls ^(Form) ,^(Controls) ka dibna dooro ^(Control)O K. Sanduuqa wada hadalka Kontoroolka Foomka ayaa soo bixi doona . ^{(Form Control)}Guji Xakamaynta^(Controls) si aad u samayso isbeddelkaaga; dooro isku xirka unugga^{(Cell Link)} meesha aad rabto in Kontroolka^(Controls) lagu qaado. Maqaalkan, waxaan dooranay unugga $E$2 . OK Waxa la samayn doonaa Bar-rogid ^{(Scroll Bar)}Markaad gujiso falaarta bidix ee Scroll^{(Scroll Bar)} , lambarkaWuu yareeyaa^(Decreases) marka aad gujiso fallaadha midig ee Bar^{(Scroll Bar)} -wareejin , nambarku wuu kordhiyaa^(Increases) .

9] Sida loo sameeyo batoonka Spin

Guji Gelida^(Insert) , dooro batoonka Spin^{(Spin Button)} . Isticmaal calaamadda qaabka iskutallaabta ee ka muuqata xaashida shaqada si aad u sawirto badhanka Spin^{(Spin button)} . Kadibna midig-guji dooro Koontaroolada Foomamka^{(Form Controls)} ; ka dooro Control tab ee sanduuqa wadahadalka Form Control , samee wax kasta oo isbedel ah haddii aad rabto, dooro isku xirka Cell^{(Cell Link)} adigoo gujinaya qaybta Cell Link , ka dibna taabo unug waxay ka muuqan doontaa sanduuqa gelitaanka Cell Link ka dibna OK . Hadda waxaan haynaa badhanka Spin^{(Spin Button)} . Guji badhanka fallaadha-korka; tirada ayaa kordheysa^(Increases) ; guji batoonka fallaadha hoose fallaadhu Way dhimaysaa^(Decreases).

10] Sida loo sameeyo sanduuq kooxeed

Guji Gelida^(Insert) , dooro sanduuqa Kooxda^{(Group box)} , isticmaal calaamada qaabka iskutallaabta si aad u sawirto Sanduuqa Kooxda^{(Group Box)} . Si aad xogta u geliso Sanduuqa Kooxda^{(Group Box)} , midig-guji, dooro Edit Text , ama laba jeer taabo midigta ka baxsan Sanduuqa Kooxda^{(Group Box)} .

Waxaan aaminsanahay in tani ay caawineyso.

Hadda akhri^{(Now read)} : Sida loogu daro ama loo beddelo Mawduuca Buugga Shaqada ee Microsoft Excel^{(How to add or change the Theme for Workbook in Microsoft Excel)} .

How to create and use Form Controls in Excel

In Microsoft Excel, Form Controls, it is useful for selecting items in a list of a dialog sheet. Form Controls makes it easier for the users to interact with the cell data that they have created. Several Control Forms will add to your worksheet; these are Label, Group box, Checkbox Button, Option Button, List Box, Combo Box, Scroll Bar, and Spin Button.

The Types of Form Controls

• Label: Labels shows descriptive text such as pictures, titles, and caption, it also identifies the objective of a cell.
• Group box: Closely related contents are grouped with an optional label.
• Button: this Control runs a macro and performs an action when a user clicks on it.
• Check Box: this gives the user the option to turn on and off a value that implies the opposite choice. You can select more than one Check Box.
• Options Button: Like the Check Box, it also gives you the option to turn on and off a value that indicates an opposite choice. The only difference is that the Option Button only allows the user to select only one choice, unlike the Check Box.
• List Box: Displays a list of text items that the user can choose from.
• Combo Box: This is a text box with a list box to create a drop-down list box. The combo box allows the user to click a drop-down arrow to display the list.
• Scroll Bar: Scroll through a range of values using the scroll bar arrow keys or drag or drag the scroll box.
• Spin Button: This increases or decreases values such as numbers, dates, or time. To increase the value, click the up arrow; to decrease the value click the down arrow.

Create & use Form Controls in Excel

In this article, we are going to discuss these topics:

1. How to Find the Form Controls
2. How to Create a Label
3. How to create a Button
4. How to create a Check Box
5. How to create an Option button
6. How to create a List Box
7. How to create a Combo Box
8. How to create a Scroll Bar
9. How to create a Spin Button
10. How to create a Group Box

1] How to Find the Form Controls

Right-Click on the Standard Tool Bar and select Customized the Ribbon. A dialog box will pop up called Excel Option. On the left of the dialog box, click the Check Box beside Developer, then OK. On the Menu Bar, you will see the Developer tab.

2] How to Create a Label

On the Developer Window, click the Insert Tool, you will see a list of the Control Forms. Click Label. You will see a cross-shaped cursor appear; use it to draw the Label, then right-click and select Edit Text to enter your text in the Label.

3] How to Create a Button

Go to the Insert Tool in the Controls Group. Select the Button Tool. You will see a cross shape cursor; drag it across to create the button.  An Assign Macro dialog box will appear. Click OK.  You will see a button in the excel sheet.

4] How to Create a check box

Go to the Insert Tool and select the Check Box Tool. A cross shape cursor will appear draw your Check Box. Now you have a Check Box. To rename, right-click the Check Box and select Edit text.

5] How to create an Option button

In the Insert Toolbox, select the Option Button. There will be a cross shape cursor; take the cross-shape cursor, and draw your Option Button. To enter text into the Option Button, right-click or double-tap in the button and enter your text or right-click and select Edit Text.

6] How to create a List Box

Go to the Insert Tool, select List Box; a cross-shaped cursor will appear in the workbook, and use the cross-shape cursor to draw the List Box. To enter data into the box, right-click the box, and select Format Control, a Format Control Dialog Box will appear, click on Control, click into the Input Range entry, then go over the cell that you want to be in the list, click on it and drag it down. The input range selected is in the Input Range in the dialog box, now click into the Cell Link entry and choose a cell where you want the Cell Link to be inserted.

The Cell Link will display whatever data you click in the List Box; the row will appear for every value selected. Then OK. If you want the List Box to show the rows for every number you selected within the box, click the range of cells you selected, click any of the data in the list and display which row the data is in. If you want to show only the list data, use this formula =INDEX (B2:B7, J2, 0). B2:B7 is the range of cell you selected, J2 is the row that you have displayed before. When you press enter, you will see the original number from the list when you click on any number within the list.

7] How to create a combo Box

Click the Insert Tool, select Combo Box. Use the cross shape cursor to draw the Combo Box, right-click the Combo Box, select Form Controls, click into the Input Range, then go over the cell that you want the list to be in and drag it down, click into the Cell Link and choose a cell where you want the Cell Link to be placed. In this article, we put it over the Combo Box that was drawn. Then OK. Now you have a functional Combo Box in your workbook.

8] How to create a scroll Bar

Click Insert, select Scroll Bar, draw the Scroll Bar in the worksheet, then right-click, select Form Controls, and then select OK. Then right-click the Scroll Bar, then select Form Control. A Form Control dialog box will pop up. Click Controls to make your changes; select a Cell Link where you want the Controls to be taken. In this article, we choose the cell $E$2. OK. A Scroll Bar will be created. When you click on the Scroll Bar‘s left arrow, the number Decreases when you click on the right arrow of the Scroll Bar, the number Increases.

9] How to create a Spin Button

Click Insert, select the Spin Button. Use the cross shape cursor that appears in the worksheet to draw the Spin button. Then right-click select Form Controls; select the Control tab in the Form Control dialog box, make any changes if you want, select a Cell Link by clicking into the Cell Link entry, then click a cell it will appear into the Cell Link entry box then OK. Now we have a Spin Button. Click the up-arrow button; the number Increases; click the down arrow button the arrow Decreases.

10] How to create a group box

Click Insert, choose Group box, use the cross shape cursor to draw the Group Box. To enter data into the Group Box, right-click, select Edit Text, or double-tap right outside the Group Box.

I trust this helps.

Now read: How to add or change the Theme for Workbook in Microsoft Excel.

Related posts

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loogu isticmaalo DEC2Bin gudaha Excel si loogu beddelo nambarka jajab tobanle ee binary

• Xisaabi leexashada caadiga ah iyo khaladka caadiga ah ee macnaha Excel

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo isticmaalo shaqada DGET gudaha Excel

• Sida loo bilaabo Word, Excel, PowerPoint, Outlook in Mode Safe

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Sida loo isticmaalo Find and FindB functional in Excel

• Sidee looga saaraa Akhri kaliya dukumeenti Excel ah?