BY TOPIC
EXCEL / VBA BLOGS
VBA MACROS BLOGS
- Recording macros (1)
- Working with ranges (4)
- Input/message boxes (3)
- Variables, arrays (3)
- Enumerations (2)
- Loops and conditions (2)
- Errors and debugging (2)
- Functions / arguments (3)
- Events (2)
- User forms (6)
- Classes (4)
- References (9)
- Files and folders (4)
- General (15)
- Working with charts (4)
- Flappy Owl (14)
BLOGS BY AUTHOR
BLOGS BY YEAR
Blogs from Wise Owl on Input/message boxes in VBA macros
Showing blogs 1-3 (out of 3)
This blog explains the lesser known but better Excel VBA InputBox function
Posted by Andy Brown on 17 December 2015
There are two ways you can display an input box using Excel macros: the standard VBA InputBox function, or the much better (but lesser known, at least by this blog's author) Application.InputBox function.
Using the InputBox Function in VBA Macros
Posted by Andy Brown on 03 October 2011
The InputBox function in Visual Basic for Applications allows you to get - as the name suggests - input from the user. This blog shows how to use it!
Using MsgBox to Display Messages in VBA Macros
Posted by Andy Brown on 28 September 2011
The MsgBox command in Visual Basic for Applications allows you to display basic messages, but you can also make it prettier, and even use it to ask questions or display multiple-line messages! Read on to find out more about this versatile VBA command.