How to hide Userform Option button and send userform textbox data via external email?

Hi,

I would really appreciate it if someone could help me please?

I’m trying to setup a userform that once it’s filled out it will send me an email with the data via the submit button.

I’ve managed to do most of it (the easier parts) but I’ve come across a few issues in 2 different parts.

First Part:

1. When the userform is opened, I would like it to hide the combobox and label (Existing Operators Initials).
2. It stays hidden if the “New Operator” Option Button1 is selected.
3. If Option Button2 is selected then I would like the comboBox and Label (Existing Operators Initials) to appear so they can select their initials.

Second Part:

I’ve copied a VBA code off youtube that sends the email and it kind of works because it tries to load outlook. The problem I’ve got is at my work, I have to go through the web to log into my email account. For whatever reason our emails stopped working through the outlook app about a year ago.

So I was wondering if it’s possible to alter my code so it can load outlook via the web?

I hope this all makes sense.

Kind Regards

Dan

For the first part, all controls have a Visible property. Set it False for the 2 controls in the Userform.Initialize event and True/False in the Option button Click events.

Hi Cytop,

Thanks for you reply.

I've done the false part of your message but i am struggling with it from the Initialize part.

Please could you give me a little more info?

Kind Regards
Dan

Hi Cytop,

That's perfect for my first problem. Thank You.

Kind Regards

Dan

Sorry I can't help with the 2nd part - me and coding for the internet are 2 things that are mutually exclusive...

I might suggest you mark this as solved and start another thread for that issue on its own - it's always a good idea to limit a thread to just one issue as sometimes threads with multiple issues and a couple of replies get 'overlooked'.

Hi Cytop,

That's OK, you've been very helpful with the first part.

I did think when I first posted the 2 issues together I could get messy but now you've confirmed it, I'll do it.

Thanks again

Dan