Pop-Up Window with different options//Userform vs Msgbox

[Leeeo]

Hello,
I'm still very new to Excel VBA and I'm looking for help.

I want a PopUp Window to appear in my Worksheet and give the user different options what to do.
The options will be something like "sent an email", "mark as done", "leave as is".
I want to link actions to the options, the goal would be, that when the user clicks on "sent an email" an email will automatically be sent to an email directory.

I don't know if that is possible, and if I should look into Messagebox or Userform.

If anybody could help me or just point me into a direction, that would be amazing!
Thank you so much!

Greetings,
Leo

 

[shinigamilight]

Create a Userform and populate it with command boxes, and in workbook_open event call that userform when workbook is opened automatically using the code below. Try slowly building the code by watching some YouTube videos.

Private Sub Workbook_Open()
        Myformm.Show
End Sub

"Myformm" is a custom name you can change accordingly.

This playlist is all you need if you want to learn VBA.

Excel VBA Introduction

Excel VBA is a powerful (and fun!) tool which allows you to automate your Excel workbooks. These videos will help you through your first steps on the way to ...

www.youtube.com

 

[Leeeo]

Create a Userform and populate it with command boxes, and in workbook_open event call that userform when workbook is opened automatically using the code below. Try slowly building the code by watching some YouTube videos.

Private Sub Workbook_Open()
        Myformm.Show
End Sub

"Myformm" is a custom name you can change accordingly.

This playlist is all you need if you want to learn VBA.

Excel VBA Introduction

Excel VBA is a powerful (and fun!) tool which allows you to automate your Excel workbooks. These videos will help you through your first steps on the way to ...

www.youtube.com

Thank you so much, I will do that!