VBA Tip: Input Boxes

Like a Message Box, the InputBox displays a modal dialog with a message/prompt string and a tile. With an InputBox there are nooptions for what buttons to display. The InputBox always displays a text field to capture user text input. If the user selects the OK button in the InputBox dialog the string in the text field is returned as a string.

The basic InputBox function syntax is as follows:

InputBox(Prompt string, Dialog title, Default string value)

Example:

Dim strInput As String

strInput = InputBox("Enter distance", "MyMacro", "5")

Last Month’s Tips:

EnvisionCAD

Since 1996, EnvisionCAD has been a nationally recognized leader in the configuration, customization, implementation, training & support for CAD software solutions. Our individualized approach has benefited private engineering firms and government agencies alike. Basic or advanced, we can help you get the most from your CAD technology.