adapt userform loop using control name containing variable for worksheet activex controls

Hi all,

First time posting - I have already gotten a lot of my questions answered here - thanks!

The following code works great to save data from a userform to a database on a worksheet; where my control names are CTRL1, CTRL2 etc. But I haven't figured a way to adapt the code for activex controls I have put on another worksheet(sheet 6) in the same workbook. Any ideas how to loop thru? It does not recognise any combinations I've tried using say: sheet6.OleoObject("CTR" & i).value.
TIA

Please Login or Register  to view this content.

Oops- typo there
Norrie, have tried that - code below shows what I've tried and the errors.................

Please Login or Register  to view this content.

Thank you! You solved it like that!
I'm learning slowly but this one had me stumped for sure. The loop works perfectly now. Hope this helps someone else along the way.
Final code below - saves updated record, clears out controls and disables controls:

Please Login or Register  to view this content.