agwalsh
asked on
Trying out code with command button nothing happening :-(
hi Folks
Found the wonderful Ms Dalgleish's code to add to a add record transaction and have attempted to adapt for my own uses. Alas, it's not add the items as expected. As my knowledge of code is rather sparse I suspect one of you could see where I'm gone wrong quite easily. Please find attached to this. Thank you
UserForm-01-EE.xlsm
Found the wonderful Ms Dalgleish's code to add to a add record transaction and have attempted to adapt for my own uses. Alas, it's not add the items as expected. As my knowledge of code is rather sparse I suspect one of you could see where I'm gone wrong quite easily. Please find attached to this. Thank you
UserForm-01-EE.xlsm
Rory Archibald
You have an Exit Sub line about halfway down the button click code... :)
ASKER
Yes, well even I know that doesn't help :-) let me edit delete and try again thanks
ASKER
OK, I've taken out the Exit Sub bit but now it gets stuck at the next bit (although it does add the date) thanks.
UserForm-02-EE.xlsm
UserForm-02-EE.xlsm
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Yum, that worked. Now just have to figure out how to do the last bit on hiding the form. Thank you :-) Will score ya :-)
To hide, it's
or to actually unload, it's:
Me.Hideor to actually unload, it's:
Unload MeASKER
Actually how can I set up the form so that it opens with the spreadsheet? thanks
ASKER
No objections - thank you :-)
If you agree with the proposed disposition then you might as well go ahead and do it yourself.