how to auto fill cell with vba code

hi all
thanks in advance i have some code if 133 is entered in any column c it will show a message with yes and no answer but only shows 10 times if 122, 6times, 111 2 times and so on but would also like it to auto fill corresponding cells ( same row) column f with asset and uneeded in column g if answer is yes hope you all understand thanks again
shane

Please Login or Register  to view this content.

I'm not quite sure I understand EXACTLY what you're asking for, but hopefully this points you in the right direction.

Try making these changes to your code:

Please Login or Register  to view this content.

Let me know how this goes for you. If it still isn't doing what you want, can you please upload an example workbook with a more detailed explanation so that I may take a look at this problem for your specific circumstances.

Hope I have helped

Thanks a lot your a legend work a treat

You're welcome

Please don't forget to mark this thread as solved