Move to next txtbox

**gelandl** · 08-25-2008, 07:10 AM

I have designed my user form and it seems to work except that the cursor does not move to the last box! It allows you to complete all fields and then refuses to go to the last comments field. In addition to this I dont know how to write the data from the completed forms to a spreadsheet. CAN ANYONE PLEASE ASSIST?

Very desperate

**mudraker** · 08-25-2008, 07:31 AM

You will get a better response if you paste a copy of your workbook

**dominicb** · 08-25-2008, 07:35 AM

Good afternoon gelandl

First of all, from the VBE go to View > Tab Order and make sure that ll the textboxes are there. You can then move the textboxes up or down, so that the tabbingsequence is how you want it. If this doesn't work, you may need to post your file ...

With regard to your second question, have a look at the attached file which demonstrates how to do this.

HTH

DominicB

**gelandl** · 08-25-2008, 07:39 AM

Thanks. It seems as though my code is riddled with errors.
Tab doesnt take you to comments box at end
info does not write to a spreadsheet( Icopied the code from a online tutorial and tried to tweak is for my purposes, but I had no clue what to do with the bit that writes the data on a spreadsheet.)

**dominicb** · 08-26-2008, 06:20 AM

Hi gelandl

Psssst, *whispers* it's a listbox, not a textbox, and as you've not assigned any items to it, it can't be selected. Change it to a textbox, and you'll be able to select it.

As for the copying to cells bit, have you had a look at the example file I attached?

HTH

DominicB

**gelandl** · 08-27-2008, 05:50 AM

Thanks for the tips. text box sorted, going to have closer look at the template you sent to understand the coding so that I can replicate on mine.

**gelandl** · 09-19-2008, 06:23 AM

Hi there

I am back again. I have nearly completed my userform. All the data in my text boxes are writing to a spreadsheet as meant, however the options selected do not reflect. Any help on why this information would not show?