Userform To Worksheet info please

[ipbr21054]

Hi,
Please see screen shot supplied.

I would enter a value in each TextBox then press TRANSFER DATA.
A new row should be inserted at row 3 then sorted A-Z

When i press TRANSFER DATA i see a RTE 438 as per screen shot & when debugged the line of code is shown in yellow as per screen shot.

Can you advise what i did wrong for this RTE to be shown.
Can you also advise if the rest from the re on is correct

Many Thanks

 

[mikerickson]

TextBox1 does not have a ListIndex property hence the error.

Its not clear what you are testing with that line.
What condition would make you want to show that MsgBox?

 

[ipbr21054]

Ok
Then i added it by mistake.

I wish to add data to each textbox, run transfer data, insert new row at 3 and sort A-Z

If transfer data is pressed all 3 textboxes must have a value or msg is shown

 

[mikerickson]

I assume that you removed that line.
What is the problem that you are having now?

 

[ipbr21054]

Thanks,
Last night had to change coe but now working.

Have a nice day