Inputbox Type 1 Get A Number From The User

less than 1 minute read

InputBox Example 1: (Type 1) – Inputbox to get a number from the user.

'==================================================================================================
' ## InputBox Example 1: (Type 1) - Inputbox to get a number from the user
'==================================================================================================
Sub InputBoxNumber() '// Vars Dim AgeNum As Variant '// Prompt for an age AgeNum = Application.InputBox _ (Prompt:="How old are you?", Title:="Numbers only", Type:=1) '// Test if clicked cancel If AgeNum = False Then Exit Sub '// Output MsgBox "You are " & AgeNum & " years old."
End Sub

Tags: inputbox

Categories: vba

Updated: March 29, 2019

Twitter Facebook LinkedIn

1 minute read

Here’s the simple steps to highlight the row and column of the selected cell which can be extremely useful when navigating large sets of data. Here’s a littl…

less than 1 minute read

How it Works Using SEARCH and ISNUMBER When you need to check if a cell contains specific text (or string) we need to combing the SEARCH and ISNUMBER functio…

less than 1 minute read

So you have a 0% value on one of your data labels and want to hide it?

1 minute read

Download the example workbook here: calculate-time-between-dates.xlsx

Leave a Comment