Excel VBA Topic 2.4 - Message Boxes & Input Boxes

preview_player
Показать описание
  1. CPPMechEngTutorials
  2. Visual Basic for Applications
  3. VBA
  4. Cal Poly Pomona
  5. Mechanical Engineering
  6. ME 232
Рекомендации по теме
BEYOND THE MACRO 0:28:01

BEYOND THE MACRO RECORDER 2/4 - Loops In Excel VBA

Excel VBA Dictionary 0:08:37

Excel VBA Dictionary vs Collection (2/4)

Excel VBA Topic 0:06:39

Excel VBA Topic 2.2 - Creating Your First VBA Macro

Excel VBA Topic 0:04:49

Excel VBA Topic 2.1 - Accessing the VBA Environment

Excel VBA Topic 0:10:18

Excel VBA Topic 4.1.2 - Example, Reusing a Sub Procedure

How to Master 0:08:37

How to Master VBA loops FAST (with real coding examples)

Excel VBA Topic 0:09:22

Excel VBA Topic 4.2 - Variable Scope and Variable Lifetime

Excel VBA - 0:00:56

Excel VBA - Introduction to Topic 2

Excel VBA for 0:09:20

Excel VBA for Post-Beginners: (2/6) Record Code to Duplicate Sheets

Excel VBA Topic 0:08:10

Excel VBA Topic 2.4 - Message Boxes & Input Boxes

Learn Excel VBA 0:14:02

Learn Excel VBA to Automate Anything

How I Made 0:11:36

How I Made 2 VBA Applications Run Ultrafast

Excel VBA Topic 0:11:00

Excel VBA Topic 2.3 - Variables

Excel VBA Topic 0:17:08

Excel VBA Topic 1.5 - Relative vs Absolute References in Worksheets

Excel VBA 0:06:44

Excel VBA For Loop Example 1

Excel VBA: Copy 0:12:20

Excel VBA: Copy Data from one Sheet to Another (Absolute Vs. Relative Macro Recording)

VBA Programming for 0:03:28

VBA Programming for Excel 2010 - V2.04 - Calling and Combining Sub Procedure Macros

Excel VBA Beginner 2:10:31

Excel VBA Beginner Tutorial

MICROSOFT EXCEL VBA 3:58:29

MICROSOFT EXCEL VBA - COMPLETE 4 HOUR COURSE

Sumifs formula in 0:00:18

Sumifs formula in excel | Excel formula #shorts #sumifs

Excel VBA Online 0:10:08

Excel VBA Online Course - 1.4.2 Parameters and Arguments

Excel VBA Tutorial 1:37:40

Excel VBA Tutorial for BEGINNERS [VBA Macros in Excel]

Change number in 0:00:24

Change number in date format | Excel formulas | Text Function

Excel VBA Topic 0:03:39

Excel VBA Topic 1.2 - Order of Operations

Комментарии
Автор

You would force them to put in the correct value by using a loop that only let's you leave the loop if you receive "acceptable" input.

davidschoenborn
Автор

How do you force the user to enter numerical values in the InputBox? If someone accidentally types a letter in, this will distort the result when using numerical operations.

jasminamrkonja
Автор

Hi, why it isn't necessary to dim variables num1, num2 and ans?
Wen shortening the macro to :
num1 = Range("B2")
num2 = Range("B3")
ans = num1 + num2


It request dimming the variables

edvirgiliom
Автор

I noticed that too.  If anyone know c++, we can do input validation but not sure how you would or could you do so in VBA.

erickwan
Автор

Not sure how to force users to do anything.  Fortunately, VBA continues on computing if a letter is used.  It merely assigns a "value" of zero to the entry.  Try it.  One way to alert them that they have made an error is to echo their inputs back to them using the message box, as Dr Nissenson's example does for the first value.  Simply add one more line of code to echo the second number, and your user has a better chance of discovering his/her mistake when the code is run.

ToddCoburn
Автор

Hey when i write the code (MsgBox num1&"+"&num2&"="&ans) in the last line of Sub inout(), it highlights the + sign and shows error Expected:End of statement. Please advise

adityabansal