userform checkboxes

Hello Everyone, I am working on a Userform and need your urgent help on the same. Purpose of this userform to open relevant workbook which are attached in workbook as Object In userform i have a drop down by the name of ComFruit under that there are fruits name like Apple1, Apple2 and...

Good evening! I've been battling all day with a piece of code that I'm using to try and create a fool proof system for our engineers to use, but I've hit a stumbling block. I have a userform, that when the UIN is input, it populates the existing fields from the spreadsheet to allow them to be...

Hello there, I need multiple users in various Fantasy groups to populate a worksheet for me. I don't want the exercise to be cumbersome, hence a Userform. I need to achieve the following: User Selects their group (sample options below): Fantasy Group 123 Fantasy Group 1234 Fantasy Group 12345...

I have a Userform having several Checkboxes and a Button to perform action. I want to loop through all checkboxes, If the value of check box is true it should show its Caption in MsgBox. but my code return error. Dim C As MSForms.Control For Each C In Me.Controls '<--| loop through...

Hi all, Situation: A checkbox on a userform is set to .Value = True and .Enabled = False. My Question: Is there a way to click the disabled checkbox and have it set itself back to .Enabled = True and also changing the Value back to False? I do not want to re-enable it through clicking...

Hi I am a newbie to <acronym title="visual basic for applications">VBA</acronym> coding in Excel and this one is just too complex for me to get my head around with userforms and combining checkboxes etc, so reaching out to this great forum I have had so much success with :smile: When you...

I cannot thank this board enough! This is my first major post/request. (Many thanks to Rick and AlphaFrog for their contributions to this) So, I have a userform to record very simple payroll data. The user selects a worker (individual), work performed, and then enters a quantity...

Hello! I have a database for years from 2005-2020 with value. I created an Userform with check boxes. 15 check boxes each one is a year date. (This is my starting point) What I need if possible If I tick 2007,2008,2015,2019 for example I would like that when I press a "Ok" button in the...

Hi, I'm red raw to excel and trying to make a userform that uses a multi-select checkbox in a listbox. I've searched the net and been able to copy code from tutorials etc. to make my form and input my data eventually. The only problem is the multiselect checkbox won't populate my worksheet...

Hope somebody can help me out... I created a userform to send the information in it via outlook. It works "fine" but I would like to change two things and it has been complicated. The userform has 2 textboxes and 2 checkboxes. I need the userform to display an error if 1 of the textboxes has no...

I have been racking my brain and spent weeks now trying to build functionality into an excel project cost estimation tool that will allow the user to create their own 'view' of a table based upon parameters from checkboxes in a user form. Apologies for my lengthy and detailed description. The...