Pop up message when opening a template

I am building an order form for clients to fill. The Excel file is a template which they download from our website.
When they first open the file, I would like to have a window pop up to give them some instructions.
Something like
"Thanks for contacting us.
Please fill up the yellow boxes."

None of what I find by googling this question deals with the Mac and works for me.
Any idea?

Thanks to all.

All you need is a simple userform.

on a PC

Please Login or Register  to view this content.

On the user form all you need is a tab letting the user switch between sheets

each sheet to have one text box with instructions.

I am trying to borrow a mac to test this for you.

I will try and post something written on a mac.

BRB

Ok

This was written on a mac

so it is not great [ Non mac user here ]

Thanks for trying but this is an empty Excel workbook.
Switching between sheets? My file has only one sheet. I did not mention switching, just a pop-up message when opening the file (workbook).

I got that.

You can have a simple pop up message on the userform.

But you can easily extend that to give more information. Using tabs in the userform.

The code above will show a userform whenever the workbook is opened.

To create a userform on a mac.

Click tools, then macros, then visual basic

Click insert userform

On the userform

insert a textbox using the toolbox,

if the toolbox isn't visible select view then toolbox.

That will give you a basic text box when you open the workbook.

Type your text into that text box.

If you want structured text, then insert a tab tool and insert text boxes on each tab

you can add tabs by right clicking and adding pages.

Thanks again for trying to help.
I have no idea what a user form is. I google it and watched videos on how to create user form. I do not wish my clients to fill this sort of form. Me worksheet is already done. I just want that when they open the template, a pop up window tells then to fill the cells that are in yellow.
Seems too complicated for me. I give up. They will probably figure out that those cells in yellow are the ones to fill.
By the way, that Excel file above comes as en empty worksheet to me.
I am not a programmer, just a simple travel consultant.

Oh

If it is that simple a simple message box might serve you well.

Please Login or Register  to view this content.