userform adds extra row whwn entering data

[cfinch100]

hi
my userfom enters a partial extra row when entering data,i have added code to delete which sometimes works and sometimes does not,has any one any ideas why this should be,entries from scan in goes to sheet3 ,where i have left the partial row in,im lost as to why it does this,any help would be good
cheers colin

[Charles]

HI,

Your main problem is the "cmdAdd". It calls the Command_Click3" too may times.(and other command clicks)
I think you need to rethink how you want your code to work.
If the "cmdAdd" is to load sheet 3 and you are wanting to go thru the "Id" you should set a "Loop" that will
look at each combobox in the "Id" until it see a box with out data.

[cfinch100]

hi charles
i added a new commandbutton1 top left,this added all command buttons together like in frmret how you showed me but it still happens,not sure about how to construct the loop correctly but will look at some threads and try to get some ideas,thanks for the info though, many thanks
cheers colin

[cfinch100]

hi charles
no luck at min for loop, not sure what you mean by command_click3 called too many times can only see it once at beginning or am i missing something,
it is supposed to loop through all command buttons until it gets to an empty box,and then send to sheet3, suppose could use comboboxes and if empty exit sub,is it along them lines,will keep looking and trying
cheers colin

[Charles]

Hi,

I revised this code so that it looks at the "Comboboxes".
Also note how I formated the code. This makes it easier to read.
Also you should not use names like this "CommandButton11_Click" for the call.
This give you the impression it's actually a command button.

Please Login or Register  to view this content.

[cfinch100]

hi charles
thats brilliant thanks ,had done very similar myself with comboboxes but for some reason did not work
thankyou once again think i get it now
cheers colin

[cfinch100]

hi charles
have been testing and if you enter barcode in first 2 boxes in frmissued,then return them in frmret it leaves first record in sheet3,but if you fun frmret with nothing in boxes it sends to sheet4 as should have done first time ,any thoughts please
cheers colin