نصيحة: اللغات الأخرى مترجمة من قبل Google. يمكنك زيارة English نسخة من هذا الرابط.
تسجيل الدخول
x
or
x
x
التسجيل
x

or

كيفية إدراج مربعات الاختيار بسرعة في إكسيل؟

كيف يمكننا بسرعة إدراج مربعات الاختيار متعددة في إكسيل؟ يرجى اتباع هذه الأساليب الصعبة في إكسيل:

إدراج خانات متعددة مع مقبض التعبئة

إدراج مربعات الاختيار متعددة مع التعليمات البرمجية فبا

إدراج وحذف مربعات الاختيار متعددة مع ضغطة واحدة باستخدام كوتولس ل إكسيل


إدراج مربعات الاختيار متعددة في التحديدات مع ضغطة واحدة:

كوتولس ل إكسيل's دفعة إدراج مربعات الاختيار الأداة المساعدة يمكن أن تساعدك على إدراج بسرعة خانات الاختيار في وقت واحد. انقر لتحميل هذه الميزة مجانا.

doc insert multiple boxboxes 10

كوتولس ل إكسيل: مع أكثر من شنومكس مفيد اكسل الإضافية، مجانا في محاولة مع عدم وجود قيود في أيام شنومكس. تحميل وتجريبية مجانية الآن!


السهم الأزرق الفقاعة اليمنى إدراج خانات متعددة مع مقبض التعبئة


في إكسيل، ملء مقبض هو وظيفة قوية للقيام أشياء كثيرة. فإنه يمكن ملء خانات أيضا. أولا، يجب إدراج مربع اختيار. قم بما يلي:

1. انقر المطور في شريط القوائم، ثم انقر إدراج، واختر صورة مربع الاختيار أسفل التحكم في النموذج. انظر لقطة الشاشة:

DOC-إدراج-متعددة checkboxes1

2. انقر على مربع الاختيار، وسترى مؤشر علامة زائد، ثم انقر على المكان الذي تريد إضافة مربع الاختيار إليه.

DOC-إدراج-متعددة checkboxes2

3. حدد خانة الاختيار ونقلها إلى خلية، ثم قم بحذف اسم مربع الاختيار.

4. ثم حدد الخلية حيث يبقى مربع الاختيار في. ثم اسحب مقبض التعبئة فوق نطاق الخلايا التي تريد ملؤها. انظر لقطة الشاشة:

DOC-إدراج-متعددة checkboxes3


السهم الأزرق الفقاعة اليمنى إدراج مربعات الاختيار متعددة مع التعليمات البرمجية فبا

إذا كنت تعتقد أن الطريقة الأولى مزعجة إلى حد ما، يمكن أن تساعدك التعليمات البرمجية فبا التالية بسهولة وسرعة إدراج خانات الاختيار متعددة.

1. انقر المطور > البصرية الأساسية، جديد ميكروسوفت فيسوال باسيك للتطبيقات سيتم عرض نافذة، انقر فوق إدراج > وحدة، وإدخال التعليمات البرمجية التالية في وحدة:

Sub InsertCheckBoxes()
'Update 20140506
Dim Rng As Range
Dim WorkRng As Range
Dim Ws As Worksheet
On Error Resume Next
xTitleId = "KutoolsforExcel"
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
Set Ws = Application.ActiveSheet
Application.ScreenUpdating = False
For Each Rng In WorkRng
    With Ws.CheckBoxes.Add(Rng.Left, Rng.Top, Rng.Width, Rng.Height)
        .Characters.Text = Rng.Value
    End With
Next
WorkRng.ClearContents
WorkRng.Select
Application.ScreenUpdating = True
End Sub

2. ثم اضغط DOC-ضرب-حساب-3 زر لتشغيل التعليمات البرمجية. وسيظهر مربع موجه لتذكيرك بتحديد مجموعة من الخلايا التي تريد إدراج مربعات الاختيار. انظر لقطة الشاشة:

DOC-إدراج-متعددة checkboxes4

3. ثم انقر فوق OK، تم إدراج مربعات الاختيار في نطاق أنيق وجميل. انظر لقطة الشاشة:

DOC-إدراج-متعددة checkboxes5


السهم الأزرق الفقاعة اليمنى إدراج مربعات الاختيار متعددة مع كوتولس ل إكسيل

هنا، يمكن أن أعرض لكم وسيلة سهلة ومفيدة لإدراج مربعات الاختيار متعددة -كوتولس ل إكسيل، بما لديها دفعة إدراج مربع الاختيار ميزة، يمكنك إدراج خانات في خلايا فارغة أو الخلايا مع البيانات.

كوتولس ل إكسيل : مع أكثر من شنومكس مفيد اكسل الإضافية، مجانا في محاولة مع عدم وجود قيود في أيام شنومك.

بعد تثبيت كوتولس ل إكسيل، يرجى اتباع الخطوات التالية:

1. حدد نطاقا من الخلايا التي تريد إدراج مربعات الاختيار فيها.

2. انقر Kutools > إدراج > دفعة إدراج مربعات الاختيار، انظر الصورة:

DOC-إدراج-متعددة checkboxes06

3. ثم تم ملء الخلايا التي اخترتها مع مربعات الاختيار كما تظهر لقطات التالية:

أدخل مربعات الاختيار في خلايا فارغة إدراج مربعات الاختيار في خلايا البيانات
DOC-إدراج-متعددة checkboxes7 DOC-إدراج-متعددة checkboxes8

نصائح. إذا كنت ترغب في حذف خانات الاختيار بسرعة، يرجى محاولة استخدام كوتولس ل إكسيلالصورة حذف صناديق الاختيار كما هو مبين في الصورة التالية. انها وظيفة كاملة دون حصر في أيام شنومك، يرجى تحميل ولها نسخة تجريبية مجانية الآن.

DOC-إدراج-متعددة checkboxes9

كوتولس ل إكسيل: مع أكثر من شنومكس مفيد اكسل الإضافية، مجانا في محاولة مع عدم وجود قيود في أيام شنومكس. تحميل وتجريبية مجانية الآن!


السهم الأزرق الفقاعة اليمنى إدراج وحذف مربعات الاختيار متعددة مع كوتولس ل إكسيل

كوتولس ل إكسيل: مع أكثر من شنومكس مفيد اكسل الإضافية، مجانا في محاولة مع عدم وجود قيود في أيام شنومكس. تحميل وتجريبية مجانية الآن!


المادة ذات الصلة:

كيفية حذف مربعات الاختيار متعددة بسرعة في إكسيل؟


Kutools for Excel يحل معظم مشاكلك ، ويزيد من إنتاجيتك بنسبة 80٪

  • إعادة استخدام: إدراج بسرعة الصيغ المعقدة ، الرسوم البيانية وأي شيء استخدمته من قبل ؛ تشفير الخلايا مع كلمة المرور إنشاء قائمة بريدية وإرسال رسائل البريد الإلكتروني ...
  • سوبر الفورمولا بار (بسهولة تحرير أسطر متعددة من النص والصيغة) ؛ تخطيط القراءة (بسهولة قراءة وتحرير أعداد كبيرة من الخلايا) ؛ لصق على المدى المصفى...
  • دمج الخلايا / الصفوف / الأعمدة دون فقدان البيانات ؛ انقسام خلايا المحتوى ؛ الجمع بين تكرار الصفوف / الأعمدة... منع الخلايا المكررة. مقارنة النطاقات...
  • حدد تكرار أو فريد الصفوف. حدد صفوف فارغة (جميع الخلايا فارغة) ؛ سوبر البحث والعثور غامض في العديد من المصنفات ؛ اختيار عشوائي ...
  • نسخة طبق الأصل خلايا متعددة دون تغيير مرجع الصيغة ؛ إنشاء المراجع تلقائيًا إلى أوراق متعددة. إدراج الرصاصات، مربعات الاختيار والمزيد ...
  • استخراج النص، إضافة نص ، حذف حسب الموضع ، إزالة الفضاء. إنشاء وطباعة مجاميع ترحيل الصفحات ؛ تحويل بين محتوى الخلايا والتعليقات...
  • سوبر تصفية (حفظ وتطبيق مخططات التصفية على أوراق أخرى) ؛ تصنيف متقدم حسب الشهر / الأسبوع / اليوم ، التردد وأكثر ؛ فلتر خاص بواسطة جريئة ، مائل ...
  • الجمع بين المصنفات وأوراق العمل. دمج الجداول على أساس الأعمدة الرئيسية ؛ تقسيم البيانات إلى أوراق متعددة; دفعة تحويل XLS ، XLSX وقوات الدفاع الشعبي...
  • أكثر من ميزات 300 القوية. يدعم Office / Excel 2007-2019 و 365. يدعم جميع اللغات. سهولة النشر في مؤسستك أو مؤسستك. ميزات كاملة النسخة التجريبية المجانية من 30.
علامة التبويب kte 201905

علامة تبويب Office توفر واجهة مبوبة لـ Office ، واجعل عملك أسهل بكثير

  • تمكين تحرير علامات التبويب والقراءة في Word و Excel و PowerPointوالناشر والوصول ، Visio ومشروع.
  • افتح مستندات متعددة وقم بإنشائها في علامات تبويب جديدة لنفس النافذة ، وليس في نوافذ جديدة.
  • يزيد إنتاجيتك بنسبة 50٪ ، ويقلل مئات نقرات الماوس لك كل يوم!
أسفل مكتبه
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Rohit · 11 months ago
    Thanks for the tips, could help me , I am trying to select multiple checkboxes and based on selection count should be displayed. could help me with macro code for same
  • To post as a guest, your comment is unpublished.
    Wayne Edmondson · 11 months ago
    Hello and thank you for the tips above. Note that in your Sub, you must declare the variable xTitleId with Dim xTitleId as String.. otherwise the routine will produce an error, assuming the user has VBA set with Option Explicit. The Dim above solves the problem and the Sub works perfectly thereafter. Thanks for the great advice and information.
  • To post as a guest, your comment is unpublished.
    Tianao Li · 2 years ago
    Great macro, gracefully written!!! Thank you!
  • To post as a guest, your comment is unpublished.
    Jeff · 2 years ago
    I just purchased the program. When I insert the checkboxes, they are slightly lower than the cell itself, so they are encroaching into the cell below. How can I reposition each of those cells?
  • To post as a guest, your comment is unpublished.
    Nesh · 3 years ago
    Hye there. im new here n new for using excel.can i know how to put other excel sheet under one excel sheet. example when i open 1 excel sheet and i got my audit plan. Then i got list of country overall such as Canada and Belgium. So what i wan to know how if i click Canada and my audit plan for Canada will appear.
  • To post as a guest, your comment is unpublished.
    Ruby Lee · 4 years ago
    Why is my name in this list? I did not take this class.
  • To post as a guest, your comment is unpublished.
    sam · 4 years ago
    Hi Just followed your code to create a list of checkboxes on my spreadsheet, I am very new to this but have managed to follow it and worked perfectly. I just cant remove the checkbox labels coming up? i have a pretty long spreadsheet and deleting them individually is impossible. can i remove the labels that come up with each checkbox??? please help
  • To post as a guest, your comment is unpublished.
    Matthew · 4 years ago
    Really good macro

    How do insert them already checked? i.e. their value is already 1?
    Thanks
  • To post as a guest, your comment is unpublished.
    Kamolga · 4 years ago
    THANK YOU!!! Great post!
  • To post as a guest, your comment is unpublished.
    LLD · 4 years ago
    Hello, this macro is a GREAT timesaver - thank you! I'm terrible with VBA, but I was trying to determine which line(s) in the code I may be able to comment to keep the range-reminder dialog from appearing. Is that possible?

    I'm prepping some checklists for our marketing group and entering a MILLION checkboxes (so you can imagine how much this macro helps), but I have to stop with each group/range and click on that darn dialog.

    Any way to disable it so I can maybe re-enable it later? Thanks for any help! -LLD
  • To post as a guest, your comment is unpublished.
    JeffFromTims · 4 years ago
    I'm attempting to make a call log (in a table format) that has check boxes. I want to be able to sort/filter the table and have the check boxes move accordingly with the other data. At the moment, they're fixed.
  • To post as a guest, your comment is unpublished.
    TipTup21 · 4 years ago
    Great Post!

    Is there a Way to do the VBA Code with toggle buttons?
  • To post as a guest, your comment is unpublished.
    Jessica · 5 years ago
    :-) Hello,
    Thanks for the tips! I was wondering, is there another simple way to insert checkboxes into the actual cell..vs floating?
    Also, can you insert...
    -as a dropdown field - categorizable (is that even a word? ;/)
    -in the cell - so you can format alignment

    thanks!
  • To post as a guest, your comment is unpublished.
    Brian · 5 years ago
    I have an xml mapped excel spreadsheet where a user copies and pastes a number of rows then we can export to an xml file. I would like to add a column with check boxes and have the user check appropriately then have that field export as true/false to xml. Any idea how this could be accomplished?
    • To post as a guest, your comment is unpublished.
      Kman · 5 years ago
      If I understand you correctly you have an xml mapped excel file that is intended for users to copy and paste into. Then the user users the XML Export tool to create a second file that is an XML file that is then used in another process.

      Well if you have the excel file with cells mapped you could have the check boxes setup in the file ahead of time. The checkboxes can be placed on cells that are mapped. The checkboxes insert True/False into the cells they are linked to or turn empty or to a check mark depending on what is entered into the cell. If a user pastes values into those cells the checkbox won't be affected unless that pasted value is "True" or "1". You can have the user either paste values or use the checkboxes to enter TRUE/FALSE. Once the user has gotten the excel file the way they want they can then export to XML.
  • To post as a guest, your comment is unpublished.
    Ed · 5 years ago
    [quote name="MikeC"][quote name="Danny"]Yes. Yes, there is.
    There is always a way.[/quote]

    OK. How would I accomplish this. I am not well versed in excel syntax. I have tried .text and .value (for c in the above code). With incorrect results. I have tried a myriad of things that would normally be the result but no luck.
    What I have is a large bullet list of items that I would like to [quote name="MikeC"][quote name="Danny"]Yes. Yes, there is.
    There is always a way.[/quote]

    OK. How would I accomplish this. I am not well versed in excel syntax. I have tried .text and .value (for c in the above code). With incorrect results. I have tried a myriad of things that would normally be the result but no luck.
    What I have is a large bullet list of items that I would like to replace the bullet with a check box and have the value and text of that box be the original text of the bullet item[/quote]
    replace the bullet with a check box and have the value and text of that box be the original text of the bullet item[/quote]

    Original code, plus it takes the list that is in the cells and uses that as the text for the check box
    Sub AddCheckBoxes()
    On Error Resume Next
    Dim c As Range, myRange As Range, Text As String
    Set myRange = Selection
    For Each c In myRange.Cells
    BoxLabel = c.Value '
  • To post as a guest, your comment is unpublished.
    Jennebeth Monserat · 5 years ago
    it really helped a lot. thank to you!
  • To post as a guest, your comment is unpublished.
    Ali Mac · 5 years ago
    hi,

    this macro works beautifully for me. i needed a little favour - i would like to ensure that the checkboxes are placed bang in the centre of the cell. can someone please help?

    best regards.
  • To post as a guest, your comment is unpublished.
    Ali Mac · 5 years ago
    hi,

    would you be able to help with one small tweak to your code, which is working just great for me otherwise?

    i would like the cell to be exactly centered within the cell housing it.

    thanks and regards.
    • To post as a guest, your comment is unpublished.
      Jackeroo · 2 years ago
      [quote name="Ali Mac"]hi,

      would you be able to help with one small tweak to your code, which is working just great for me otherwise?

      i would like the cell to be exactly centered within the cell housing it.

      thanks and regards.[/quote]

      For Each Rng In WorkRng
      With Ws.CheckBoxes.Add((Rng.Offset(0, 1).Left - Rng.Left) / 2 + Rng.Left - 8, Rng.Top, 0.33, Rng.Height)
      .Characters.Text = Rng.Value
      End With
  • To post as a guest, your comment is unpublished.
    Cole · 5 years ago
    Hey, I found this and it works great, but im using it for a daily checklist and i put rows, and when i check one box (i.e. in row 3) all check boxes in that row are checked.

    Is there a way to make each check box individual/independent?
    • To post as a guest, your comment is unpublished.
      Kman · 5 years ago
      You need to either delete those check boxes that are linked and re-create them with the macro or you can try the code I posted earlier that resets the link between cells and check boxes.
  • To post as a guest, your comment is unpublished.
    xyz · 5 years ago
    The code worked great. Thank you!
  • To post as a guest, your comment is unpublished.
    Kman · 5 years ago
    Sub RelinkCheckBoxes()
    'You select cells that include the checkboxes that are acting weird.
    'Then you run the macro.
    'It changes those checkboxes so that the linked cells correspond to the cells underneath.
    'Also it makes the checkbox text turn into the cell text.

    Dim ckbox As Shape
    Dim rngLinkedCell As Range

    If ActiveSheet.CheckBoxes.Count = 0 Then Exit Sub

    'Test that selection is a range.
    If TypeName(Selection) "Range" Then Exit Sub


    For Each ckbox In ActiveSheet.Shapes
    'Test that the shape is a control.
    If ckbox.Type = msoFormControl Then
    'test that the control is a checkbox
    If ckbox.FormControlType = xlCheckBox Then
    'find the cell under the checkbox that is within the selection
    Set rngLinkedCell = Application.Intersect(ckbox.TopLeftCell, Selection)
    'assign a new link address and rename the checkbox to match.
    If Not rngLinkedCell Is Nothing Then
    With ckbox
    .OLEFormat.Object.LinkedCell = rngLinkedCell.Address
    .Name = rngLinkedCell.Address
    .TextFrame.Characters.Text = rngLinkedCell.Text
    End With
    End If
    End If
    End If
    Next
  • To post as a guest, your comment is unpublished.
    FAISAL · 5 years ago
    how to change cell address
  • To post as a guest, your comment is unpublished.
    Reuben · 5 years ago
    I have a excel spreadsheet that has a question and then to the right are other columns "Controls Met, column f and G with check boxes that have been check, column F yes or column G no. I only want to use the filter to get each of the rolls that have a check mark, but the filter does not see s check mark
  • To post as a guest, your comment is unpublished.
    Meg · 5 years ago
    Hey guys, this is so helpful - thanks! Quick question, I'm completely inexperienced with this type of stuff so sorry if it's a stupid one! I would like to just have tick boxes (without the true or false) and I would like the boxes to be yellow when not ticked but have no fill once ticked, to indicate students who have not handed in drafts and assessment, etc. Is this possible? Could someone please post the actual code for this, or walk me through it? Many thanks in advance!!!
    • To post as a guest, your comment is unpublished.
      FAISAL · 5 years ago
      how to change the reference address for multiple checkboxes
  • To post as a guest, your comment is unpublished.
    MikeC · 5 years ago
    Is there a way to have the checkbox text be the text of the selected cell?
    • To post as a guest, your comment is unpublished.
      Danny · 5 years ago
      Yes. Yes, there is.
      There is always a way.
      • To post as a guest, your comment is unpublished.
        MikeC · 5 years ago
        [quote name="Danny"]Yes. Yes, there is.
        There is always a way.[/quote]

        OK. How would I accomplish this. I am not well versed in excel syntax. I have tried .text and .value (for c in the above code). With incorrect results. I have tried a myriad of things that would normally be the result but no luck.
        What I have is a large bullet list of items that I would like to replace the bullet with a check box and have the value and text of that box be the original text of the bullet item
  • To post as a guest, your comment is unpublished.
    Ejaz-Ul-Haque · 5 years ago
    Thanks a lot!,
    for check box.
  • To post as a guest, your comment is unpublished.
    Priyanka · 5 years ago
    Can we then filter those check boxes? Basically display only those who attended?
    • To post as a guest, your comment is unpublished.
      Kman · 5 years ago
      Yeah totally. The checkboxes are actually independent of the cells. They basically float over the spreadsheet and are linked to a cell by address inserting True and False values when clicked (or N/A if you make it a three-state checkbox).

      But when you filter in excel it hides specific rows. It will not hide the check boxes. I really don't suggest filtering with this macro. Strange things will happen and you might not realize when there are several check boxes sitting on top of each other or that two check boxes are linked to one cell and a cell is linked to no checkboxes.

      What I usually do is I will create a list and instead of checkmarks I will type a 1 or a 0 into the adjacent cell and then total. You can even pivot table the thing if your information gets complicated. For instance say you had another column that had the gender of your attendees. You could figure out how many men and how many women attended.
  • To post as a guest, your comment is unpublished.
    Priyanka · 5 years ago
    Can we then filter on those check boxes? Basically display only those who attended?
  • To post as a guest, your comment is unpublished.
    Kman · 5 years ago
    The check boxes go a bit nuts when you copy them with their linked cells. I had to write a thing to reset the linking for when I want to copy those cells somewhere else.
  • To post as a guest, your comment is unpublished.
    CM_Mario · 5 years ago
    It keeps giving me an error when I open it that it had to fix errors? Any assistance? If someone would like to help I will post the report that I'm getting from Microsoft office.
  • To post as a guest, your comment is unpublished.
    Violet · 5 years ago
    The code works great! I edit the color now I'd like to center the checkboxes in each cell, any idea what I would need to modify for that? Thanks!
    • To post as a guest, your comment is unpublished.
      Jackeroo · 2 years ago
      [quote name="Violet"]The code works great! I edit the color now I'd like to center the checkboxes in each cell, any idea what I would need to modify for that? Thanks![/quote]
      For Each Rng In WorkRng
      With Ws.CheckBoxes.Add((Rng.Offset(0, 1).Left - Rng.Left) / 2 + Rng.Left - CkBoxSize, Rng.Top, 0.33, Rng.Height)
      .Characters.Text = Rng.Value
      End With
  • To post as a guest, your comment is unpublished.
    Lior · 5 years ago
    I did it but when I check one boc, all are being checked together. how can I separate them?
  • To post as a guest, your comment is unpublished.
    # Sean · 5 years ago
    When I did this, everything worked great (Thank you!) except when the boxes are checked, it automatically has a yellow fill color in the cell. How do I make it to where the only thing that happens is the box is checked, no fill color?

    Thanks!
    • To post as a guest, your comment is unpublished.
      Dennis · 5 years ago
      [quote name="# Sean"]When I did this, everything worked great (Thank you!) except when the boxes are checked, it automatically has a yellow fill color in the cell. How do I make it to where the only thing that happens is the box is checked, no fill color?

      Thanks![/quote]


      Just change the line like it says in the comments:

      .FormatConditions(1).Interior.ColorIndex = 6 'change for other color when ticked

      Leave it out completely if you don't want a color change.

      Cheers!
  • To post as a guest, your comment is unpublished.
    O · 5 years ago
    AWESOME! Thank you so much!
  • To post as a guest, your comment is unpublished.
    Suleman · 5 years ago
    Excellent work. Thank you :roll:
  • To post as a guest, your comment is unpublished.
    Jack · 5 years ago
    excellent macro works add checkbox in the cell, thank u :-)
  • To post as a guest, your comment is unpublished.
    Daniel · 6 years ago
    Why is there only one boy in this class????
    • To post as a guest, your comment is unpublished.
      Jay Chivo · 6 years ago
      [quote name="Daniel"]Why is there only one boy in this class????[/quote]
      :lol: That's just for demonstration.
  • To post as a guest, your comment is unpublished.
    Prem Gurung · 6 years ago
    Great trick... I enjoyed it.
  • To post as a guest, your comment is unpublished.
    Jamie · 6 years ago
    Excellent macro that works beautifully to quickly and easily insert check boxes into a selected range; thank you.

    Would you consider showing an example of a macro to insert in a selected range a customized drop down list with three options: "Yes", "No", and "Maybe"?