Change Userform captions individually using a rage VBA code

Hi all,

I have a code whereby a userforms checkbox captions values are set to be the value in a specific cell, for around 20 different check boxes.

The following code does what I need, but on an individual level, whereas I was wanting a type of range code so one code can cover all check boxes individually.

Here's my current code:

Please Login or Register  to view this content.

I don't believe the 'check box visible true' code is required, but is there a way I can code the above to effect a range of cells and captions?

Just for confirmation, Checkbox1's caption must be cell A2, checkbox2's caption must be referenced to cell A3 and so on.

Hoping there's a way to do this to avoid writing individual conditional coding.

Thank you very much!

Hi Robert,

Thank you very much for such a quick reply! Haha name has been my gamer tag for years now, first time I've heard cute though thanks haha.

That code seems to be working perfectly, just looks like I'll have to move the other rows of data to be under column A, but otherwise a perfect solution!

Again amazing experience, thank you very much for making this so simple and efficent! I really appreciate you replying so fast!

Haha Oh sorry about that, yes that is the case, however currently I have 3 rows of different deals on the sheet. I can amend the code to relate to each column for the checkbox captions That should be easy with your layout and my basic understanding of VBA

cannot thank you enough for the assistance, and absolutely happy to mark as resolved Your a legend mate