VBA Input Message Boxes – how can I create them in my spreadsheets?
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!
If you would like a copy of the example spreadsheet shown in the video to try it out yourself, then please drop us an email.
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?