checbox

Hello, I have what is supposed to be a simple problem with dynamic Checkbox. I'm making a list CheckBox in UserForm. Dim chkbox As MSForms.CheckBox Dim i As Integer For i = 1 To 3 Set chkbox = Me.Controls.Add("Forms.Checkbox.1", "Checkbox_" & i) chkbox.Caption = "Test " & i...

Hi All, I hope so one can help me, I have a UserForm with 9 Checkboxes (1 to9) and each Checkbox relates to a specific range of cells from 9 separate worksheets. I have set the ranges to Rng1 to Rng9 I want to add only the ranges (Rng1 to Rng9) that have been checked as true to an array...

Hi All, Need a help on resolving the below scenario. I have a column A with Months and Column B with unique products ID's. Each months are having checkbox and i need based on the check box selection, the text box and excel sheet should be updated with the all the products from that specific...

Hi.. I'm trying to use 5 check boxes and 2 radio controls depending on the check box values. My requirement is to enable those 2 radio controls when the check boxes 3-5 are checked. I've written the code below which partially fulfills my requirement, i.e., it's enabling the radio controls when...