write to 2 sheets from userform

[cfinch100]

hi
I was given the code below which works for "sheet1",but when adapted it to write to sheet repairs as well, nothing writes to sheet "repairs",
have tried different codes that works writing to 1 sheet , but am having trouble writing to both sheets from a macro,i know it can be done
any help /pointers please
cheers colin

Please Login or Register  to view this content.

[p24leclerc]

This seems to be only part of your macro though.
One thing I can say from a first look is that you don't want to change the assigment of "ws" in the middle of a "With" statement. Never.

Do you only want to write on sheet "Repairs" or you also need to find where the combobox1 value is located on that sheet too? It can change lots of thing.

It would be a good thing to attached a sample workbook so we can work out your macro. In the air like this, it is hard to be very specific.

[cfinch100]

hi
sorry for late reply thanks for looking at it,have loaded program,it is userformservice when id is entered from combobox and date scrapped is entered ,copies to sheet1 where con format highlights and scrapped is entered ,also the id number is deleted and then transferred to different column so can not be selected through frmissue,data on formservice should also go to sheet repairs which it does not all other things work ok,i know its something ive added but can not see why it would not work
hope this explains
cheers colin

[Norie]

Colin

You shouldn't try and send the data to both sheets at the same time, use separate code for each sheet.

[cfinch100]

hi norie

have just amended code and it now sends to both sheets,can you tell me why I should use separate code when this seems to work for now,thought you could
thanks colin

Please Login or Register  to view this content.

[p24leclerc]

This macro structure should work:

Please Login or Register  to view this content.

Remark that I created a second worksheet variable so you use it to address sheet REPAIRS.
With the indentation, it is easier to see where a statement (IF - WITH - ...) starts and ends.
You're not actually using a separated code to write on both sheet, you are just doing it one after the other.
With a structured code, it's always easier to follow the process and see if something is wrong.

[cfinch100]

hi p24leclerc
many thanks for that works just how should do,had sort of done myself but yours is structured better
cheers for pointers and code change
colin