98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Loading a form
Loading a form
Resolved · High Priority · Version 2016
Thu 4 Apr 2019, 14:55Delegate Billy said...
Billy has attended:
Excel VBA Advanced course
Loading a form
Jens
My form will not load, you have a copy of the spreadsheet.
Thu 4 Apr 2019, 20:12Trainer Jens said...
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...
Fri 5 Apr 2019, 11:04Delegate Billy said...
RE: Loading a form
Hello Jens
It worked like a dream, super fast response many thanks.
Fri 5 Apr 2019, 11:48Trainer Jens said...
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
Mon 8 Apr 2019, 08:26Delegate Billy said...
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!
Mon 8 Apr 2019, 10:13Delegate Billy said...
RE: Loading a form
How do I send you an attachment?
Mon 8 Apr 2019, 11:14Trainer Jens said...
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
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Naming and Using ConstantsConstants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant. |
