Excel VBA Topic 5.2 - Customized Worksheet Functions

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

Excel VBA Topic 5.2 - Customized Worksheet Functions

Excel VBA Topic 0:06:50

Excel VBA Topic 2.5 - Absolute vs Relative References in VBA

AdvFinMod Topic 5 0:12:13

AdvFinMod Topic 5 Section 2 VBA Dim Statements Option Explicit Debugging

Excel VBA to 0:09:35

Excel VBA to Cleanse Data 2/5 - Excel Visual Basic (VBA) for Beginners

Excel VBA - 0:00:59

Excel VBA - Introduction to Topic 5

Excel VBA Topic 0:09:22

Excel VBA Topic 4.2 - Variable Scope and Variable Lifetime

VBA Excel 2016 0:09:03

VBA Excel 2016 Lesson 5 - Averaging numbers in VBA

Excel VBA Topic 0:09:21

Excel VBA Topic 5.1 - Function Procedures

How to Declare 0:07:32

How to Declare (Dim) and Set VBA Variables (use data types correctly)

Excel VBA Topic 0:11:00

Excel VBA Topic 2.3 - Variables

Learn Excel VBA 0:14:02

Learn Excel VBA to Automate Anything

Excel VBA Topic 0:08:10

Excel VBA Topic 2.4 - Message Boxes & Input Boxes

Excel VBA Objects: 0:12:04

Excel VBA Objects: Shape Object (Part 2)

Excel VBA Topic 0:05:21

Excel VBA Topic 2.6 - Recording Macros

VBA in Excel 0:15:04

VBA in Excel - Workbook 5 - Stress Calculator Part 2

Excel VBA Topic 0:10:18

Excel VBA Topic 4.1.2 - Example, Reusing a Sub Procedure

Excel VBA Topic 0:10:32

Excel VBA Topic 6.1 - Relational and Logical Operators

AdvFinMod Topic 5 0:06:06

AdvFinMod Topic 5 Section 1 VBA Basics

AdvFinMod Topic 5 0:16:31

AdvFinMod Topic 5 Section 6 VBA Matrices and Arrays and OPTION BASE 1

AdvFinMod Topic 5 0:08:14

AdvFinMod Topic 5 Section 4 VBA FOR Loops and Aggregation

Excel VBA Topic 0:06:39

Excel VBA Topic 2.2 - Creating Your First VBA Macro

AdvFinMod Topic 5 0:13:53

AdvFinMod Topic 5 Section 7 VBA Nested Loops and Multidimensional Arrays

Excel if function 0:00:48

Excel if function | Excel if formula | Excel if formulas and functions | Excel if statements

Excel VBA Forms 0:28:01

Excel VBA Forms Part 2 - Running and Navigating Forms

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

Great video.  Very simple and easy to follow, yet the topic is powerful enough for me to see myself getting a lot of use out of it at work.  Thank you for offering this class!

ScrtAznMann
Автор

Do you always have to manually type the commas? I tried dragging but I assume it doesn't get assigned to the functions in the Module.

Just saying because if there was a lot more data it would take awhile typing each comma.

t_uba
Автор

Hello,  I've copied the vel function exactly is as shown in the video, but excel is giving me an error (the #NAME? error) when I type =vel(B2, B3, B4) as if the function is not defined.  What would cause this?

joshuadavis
Автор

just a comment for people who might use other versions of Excel, as for me I need to use ";" instead of ", " between the arguments of a function

kzzrjsw