PDA

View Full Version : Copy but delete



steads1980
02-24-2011, 02:13 PM
Hi,

I am trying to amend the attached spreadsheet so when I click the update button the selected text updates the data sheet with changes but then it doesn't disappear but I don't know where or how to amend! Also I would ideally like to put a message in after 'Update Saved' I think I can probably work this bit out. Any help would be much appreciated. SPREADSHEET ATTACHED

someboddy
02-24-2011, 02:59 PM
I didn't really understand - do you want the data in the input form to disappear or to stay? 'cause right now, your code tells it to disappear(modData line 103) and that's exactly what it does.

Also if you want to put a message you can just use msgbox - I've seen it a few time in your code - or maybe you got a legacy code and that's why you have problems?