macronot running until userform closes

Hi all

i have the following code

Please Login or Register  to view this content.

now when i clidk the invoice button the dates and company name go straight to the sheet as it supposed to but....its only when the userform closed that the information of work done during the week gets put on the form and not at the same time as the dates etc. can anyone help please.


here is the form

https://www.dropbox.com/s/8dj6ygt7s7...Test.xlsm?dl=0

the macros work ok on the sheet itself as they are set up differently its just the userform im having issues with

file is 3,933Kb its to big to upload thats why i put a drop box link up....its safe

Originally Posted by Learning ExL

file is 3,933Kb its to big to upload thats why i put a drop box link up....its safe

i think thats worked

Originally Posted by skywriter

It did and I apologize because I went back to drop box to look around and there was an option there to not sign up and just download the file.

lol accepted

on the userform just use the date as 22/05/2015 and 28/05/2015

on the sheet use the same but in both sets of boxes on the right

Originally Posted by skywriter

Replace your existing code with this:

Please Login or Register  to view this content.

The will not make the user form disappear will it as when this whole workbook is done no one will see the sheets just the userform

The whole workbook will he hidden and just the userform will be open

Originally Posted by skywriter

You can remove the hide statement at the top and the unload statement at the bottom.

The real problem is you have disabled Screen Updating so the screen updating true is the only line you need and you should be fine.

you my friend are a Geneus (cant spell for toffee lol) it worked thank you