Billy has attended:
Excel VBA Advanced course
Loading a form
Jens
My form will not load, you have a copy of the spreadsheet.
RE: Loading a form
Hi Billy,
Thank you for the forum question and thank you for the nice feedback.
It is very strange what happen to your file today. I have tested it and the userform does load but is invisible. I can see this by pressing enter after load. This will give you the message box "Please select I-Rep option". Why it is invisible, and why only on the PCs we used on the course is a mystery. I have tried to Google it without luck.
I ended up recreating the form and I "cleaned" the codes and now everything works again.
Please find the attached file just under my signature. If you cannot see it please refresh the browser after a couple of minutes.
Please let me know if you have any problems with the file.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
RE: Loading a form
Hello Jens
It worked like a dream, super fast response many thanks.
RE: Loading a form
Great Billy,
Thank you letting me know and good luck with the rest of the project.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Loading a form
Hello Jens
In our project we have a form called Frm5Min, I have added a button to send the completed form as an email. I am happy on the way i set this up but I'm not sure how to tell the email to send the completed form.
could you please advise!
RE: Loading a form
How do I send you an attachment?
RE: Loading a form
Hi Billy,
Thank you for the forum question.
What you want is to attach one worksheet (the form) to an email.
I have found two useful links, where you can find the solution and the code.
https://www.rondebruin.nl/win/s1/outlook/amail2.htm
https://excelribbon.tips.net/T008508_Sending_Single_Worksheets_via_E-mail.html
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
