commandbutton sends data to top of sheet instead of 4th row

[cfinch100]

hi
just trying to tidy this up and noticed the top line in sheet1 has an entry that should not be there have looked through frmissued and can not see why this is
can some one help clean it up please
cheers colin

[Norie]

Colin

What are you trying to tidy up?

[cfinch100]

hi norie
taking some of the modules not used and extra commandbuttons not used,its just this writing to sheet1 has got me baffled
cheers colin

[Norie]

Colin

Have you tried compiling the code, Debug>Compile?

That's what I usually a good start when trying to get rid of unused code.

As for the writing to sheet1, which of the 20+ forms should we be looking at?

[cfinch100]

hi norie
firstly its form issued / cmbadd_click that sends data to sheet3 and to sheet1 the one with the problem ,have not tried debug>compile but will give it a go now thanks
cheers colin

[cfinch100]

hi norie
have compiled all seems well apart from frmissued textbox 70 sending to wrong row on sheet1,any ideas please
cheers colin

[Norie]

Colin

In the code for that userform there are about 17 places you put the value from TextBox70 onto a worksheet.

Again, which one should we be looking at?

[cfinch100]

hi norie
this is the code for commandbutton 3 which sends to sheet1, the commandbutton is one of 10 on frmissued ,they all send to sheet1 it seems if I could stop this one sending to the header rows I could adjust the others with same code ,

Please Login or Register  to view this content.

Please Login or Register  to view this content.

have included sheet1 it actually shows (this one norie) that is what I wrote in textbox70 and used combobox1 to send,it shows on top header and half way down sheet1 were it should be,bit confused why it would be 2 places
cheers colin

[cfinch100]

hi norie
what is puzzling is

Please Login or Register  to view this content.

company name is sent to same sheet1 but does not go in header as textbox70 and issued to weird or what
cheers colin

[cfinch100]

hi norie
I think ive sorted the problem textbox70 is sent to sheet1, 10 times if you use all comboboxes ,have amended code for only the first commandbutton3 to
send it and it works fine,like that, as probably you only use this textbox once, just can not understand why it was putting it in top header aswell as in proper place
cheers colin