From UserForm TextBoxes to specific cells on worksheet

G'day all,

I've used userforms before to capture input and write it to a new row of a worksheet however, management has given me a very user-UNfriendly report to fill out each out month. The report consists of a couple of pages on the one worksheet and it's a pain to read so I've made a userform to help things along. What I'm after is the syntax for taking userform input in the textboxes and writing it to specific cells on the sheet.

For example, textboxes (TB) TB1, Tb2, Tb3 and TB4 should be written to cells B5, B6, B7 and B8 respectively, TB9, TB10, TB11 and TB12 should be written to cells D5, D6, D7 and D8 respectively, and so on, for about 30 or more textboxes.

The cells are not always contiguous - the column numbers will stay the same, but the rows may be all over the shop.

If someone could point me in the right direction, I'd be grateful. Just a basic example of the syntax is all I'd need to get me started, I reckon...

Cheers,

AJ

Hi AJ,

I've had in the back of my mind that the Textbox TAG should be used for something. Here is how you might use it. Put in each Textbox Properties field of TAG the location the data is to be written. This will hardcode where the data is to be written. This may make your code easy or hard.??

Look at the attached to see this code and run it.

Please Login or Register  to view this content.

Hi Marvin,

that looks like it might suit my needs perfectly - I'll test it out at work over the next day or two and I'll get back to you.

Cheers,

AJ

Marvin,

I tried it at work last night and it worked a treat and I discovered that the listbox and combobox also have a TAG function since I may need to use one or two of those as well.

Thanks very much for the nudge in the right direction - I learned something new. :-)

Cheers,

AJ