VBA Input Message Boxes – how can I create them in my spreadsheets?

VBA input message boxes: Excel icon​This week’s hint and tip is about VBA input message boxes in Excel. It looks at how to make an Excel worksheet more interactive by using a macro with input message boxes. We also did an earlier video in a similar interactive way to this on option buttons in a group as a quiz see the video here. VBA is covered in both our Master Class Excel Bronze and Silver courses. This specific example isn’t covered in either courses, so we created a hint and tip to show you. We are going to go through it now below.

 

What is VBA?

VBA stands for Visual Basic for Applications. VBA is a programming language which lies behind Excel macros. Therefore, an Excel macro is a series of lines of VBA code which execute a series of rather tedious operations you would otherwise have to perform manually. VBA is also used in lots of other examples, however Excel macros is a common example that most have heard of before.

 

Looking at an example of input message boxes

In the workbook found below called ‘copy of input boxes’ there is a macro button and a macro behind it called addemup. The video explains how the coding that has been done in VBA produces the end effect.

This Excel example may give you an idea for the use of Excel interactively in asking question and gathering answers stored in Excel cells. We cover the use of VBAS in our Master Class Silver course and see our website for details.

We hope you enjoy testing out the worksheet.

 

A video to demonstrate the use of input message boxes in Excel

The video below shows you how to use a input message box through the use of VBA coding. We hope that you find the video useful and enjoy learning about it!

Take a look below at the video to find out more and then try it out on your own computer!

Click on button to the right to download the example spreadsheet shown in the video to try it out yourself!

We hope you have enjoyed this hint and tip on VBA input message boxes in Excel. Why not take a look at our previous one on using wrap text in Word​?

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy