Several issues with userform macro

Albert83

New Member
Joined
Nov 7, 2019
Messages
3
Hi Guys,

I have a few issues with a userform. It used to work fine but after I made a few changes it stopped working. When you fill out the form it should open 2 emails ans display them before sending them to make sure they have the necessary attachments but it only displays the second email, another issue is that the representative box should ALWAYS be rep 1 and only when a site with a GDL prefix is selected you should choose between both reps, when site is selected since there is only one option for corp name (razonsocial) is should autopopulate except for GDL N which has two options, lastly is it possible to put an image to the user form background?

Here are links to a sample file and image of how the email 1 should display.

https://1drv.ms/x/s!Auh6wwQFzC6AkX5uswvC7e3bbqVf?e=MOYyNr

https://1drv.ms/u/s!Auh6wwQFzC6AkX-OlWZ0FSXqjwl9?e=qZXh25

Any help is greatly appreciated.

Thank you for you insight and support.
 

dmt32

Well-known Member
Joined
Jul 3, 2012
Messages
5,347
Office Version
2013
Platform
Windows
Hi Guys,

I have a few issues with a userform. It used to work fine but after I made a few changes it stopped working.
Hi welcome to forum.

If your form was working ok until you made changes then can you not just revert back to an earlier version?


Dave
 

Albert83

New Member
Joined
Nov 7, 2019
Messages
3
Hi Dave,

I tried doing that but to no avail. I also tried to get the person who sent it to me but the file I havre is the only one left…

Thanks
 

dmt32

Well-known Member
Joined
Jul 3, 2012
Messages
5,347
Office Version
2013
Platform
Windows
Hi Dave,

I tried doing that but to no avail. I also tried to get the person who sent it to me but the file I havre is the only one left…

Thanks
Really sorry but I don't have time to study your project & maybe another here can but perhaps lesson should be, save the workbook as a new version each time making coding updates.

Dave
 

Albert83

New Member
Joined
Nov 7, 2019
Messages
3
Thanks Dave, hopefully someone else on the board can help out...

Regards,

Will
 

Forum statistics

Threads
1,085,458
Messages
5,383,803
Members
401,853
Latest member
Thoro

Some videos you may like

This Week's Hot Topics

Top