VBA Looping between Labels Userform

[B Eccles-Williams]

Hi,

I am new to VBA and hope that someone can help me.
I have a series of 12 different text boxes and labels within a userform that I would like to loop bewtween.
As I am not able to do this I have written the code out in full.

I would greatly appreciate if somebody were able to give me some assistance.

Many thanks,


Benedict

Please Login or Register  to view this content.

[Tinbendr]

I'm not sure if this is what you're looking for, but...

1. create a subroutine in a module.

Please Login or Register  to view this content.

2. Change the Change events to this, passing the number of the control to the subroutine.

Please Login or Register  to view this content.

3. Then if you have a command button, for instance, to write all the values back to the sheet.

Please Login or Register  to view this content.

None of this is tested. I wrote this off the cuff. So don't respond by saying, "It does not work!", unless you attach a sample workbook.

[B Eccles-Williams]

VBALooping.xlsm

Dear David,

Thank you for the help.

I have attached the workbook.

Many thanks,

Benedict

[Tinbendr]

What are you trying to accomplish?

Sent from my XT1049 using Tapatalk

[B Eccles-Williams]

Hi David,

It worked! Thank you so much.

Benedict