Inputbox and message box - How to use Inputbox and MSG box in Microsoft Excel

Input Box & Msgbox.

1.     1. Msgbox

Using Msgbox in Excel You can give some Msg to the user’s, Place the command button on Excel worksheet and check the below code.

Sub Button1_Click()

Msgbox “Hellow world”

End Sub

Result when you click the button.

2.Input box.

In Excel you can use to input some cell or (cells) range. Place a command button on your worksheet and past the following code lines.

Option Explicit

Sub Button1_Click()

          Inputbox(“Please input range”)

end Sub

Result when you click the button

3. Now Lets see how these both Msg & input box works together.

Place command button on Excel Worksheet and Please add below code.

Option Explicit

Sub Button1_Click()

Dim i As String

i = InputBox("Please enter your Name")

MsgBox "Hellow" & " " & i

End Sub

Result When you click the button.

Enter your Name and click ok.

Thats All Its cool...

Please refer the video Tutorial for above example..

Do you like this page.? Please register your Email Id for News Letter..!!