Reverse userform use

I generally don't manually program form controls anymore. I just write an address into each form control's tag value, then write a macro to read the controls.
As you will mostly likely have a number of controls like labels and such that will NOT be filled in this way I generally include verification string like "_Y" on the end

With this scheme, I can use any address scheme I want, and can add all kinds of code behaviour controls into the tag line.

As a simple version for you, I made one sub where you would simply give the sheet col reference as a letter. Hence for control you want to fill in from column B, you would edit the tag line to "B_Y"

In the second sub, I made a version to use table headers, hence a control filling from header "Call Data" would get the tag value "Call Data_Y"

NB I use sheet code names in my code. Your tab "Data" is Sheet1, while your "Sheet 1" is Sheet2. I hope this doesn't cause confusion, but code names is mush less troublesome method that doesn't break when you edit your sheet names.

Please Login or Register  to view this content.

Note that if you change the name of your table, you'll need to edit the code. However the tagline technique can be adapted to include table names or any other variable you want to work with.

I hope that this help.