Excel VBA Topic 2.3 - Variables

Показать описание

Рекомендации по теме

Комментарии

using the local window and stepping through the program (F8) brings a little more insight on how the variables are stored.

rickdickerson

Hi,

To edit the text on the added "button", I had to select the button and the easiest way was to right click it. This also bring up a drop down menu.

Thanks,
David

davidlanman

RuxandaMD, yes. That also works. You can add a couple lines to your code to test and verify.

ToddCoburn

a=a+1 can be interpreted as "replace the value in a with itself plus one".

kevinr.

Hi, big fan of the tutorials! Isthere a way to get the transcript of these tutorials?

MrZloboleon

when I would like to run the macros it gives compile error variable not defined and it points a = activecell.value. what is the reason? Although I have copied what you did properly

ElnurNamazov

"Run-time error '6': Overflow" <<< Why does the "mathisfun" module at 5:10 produce this?

Stridr

All a b c summy and divvy are variables, why you place "a" before "= activecell.value" while placing "activecell.value =" before summy. Does the order really matter ?

yijunzhu

Why do you select each cell before assigning its value to the variable? For example, instead of writing
"Range("B3").Select
a = ActiveCell.Value"
can't you just write "a = Range("B3).value"?

RuxandaMD

Why do you create a new Module1 when you type your macros? Why don't you use Sheet1 or ThisWorkbook instead? I am confused why there are all these options at the start. Are they really different? Thanks.

rgriswold

Stridr3000, check your code, each character of if, and make sure it is typed exactly as Dr Nissenson shows. You may be grabbing an empty cell.

ToddCoburn

3:22 haha that sounded like Microsoft Sam

But these are incredibly helpful, thanks!

HKT

I am writing exactly the code that the video shows and put the according values in the cells but when I run I get "Compile Error, Variable not defined". It does not recognize the value that I am trying to give to variable a. What can I do?

TheBabisflou

Excel VBA Topic 2.3 - Variables

Excel VBA Topic 2.3 - Variables

Excel VBA Topic 3.2 - Constant Variables

Excel VBA - Introduction to Topic 2

Excel VBA to Separate Worksheets to Files 2/3 - Excel VBA for Beginners

Excel VBA Topic 3.1 - Data Types

VBA Excel Combining Multiple Macros (2 or more Macros)

Excel VBA Topic 4.2 - Variable Scope and Variable Lifetime

Excel VBA Topic 9.2 - Multidimensional Arrays (matrices)

VBA- From Data Entry to Automated Emails: Build a VBA UserForm for Invoice Data Entry

Excel VBA - Introduction to Topic 3

Excel VBA Topic 4.1.2 - Example, Reusing a Sub Procedure

Excel VBA Topic 1.2 - Order of Operations

Excel VBA - Write a Simple Macro

Excel VBA Topic 4.3 - Passing By Reference vs Passing By Value

Excel VBA Topic 7.2 - For Loops

Excel VBA ActiveX Series #3 Option buttons - Use on a sheet, How to group, Select with VBA

Excel VBA to Combine Multiple Workbooks - Transfer Data from Multiple Excel Files

Excel VBA Tips n Tricks 45 Close Workbook if Password Fails 3 Times

Excel VBA Topic 3.3 - Built-in Functions in VBA

Excel Macros & VBA - Tutorial for Beginners

Excel VBA Topic 5.1 - Function Procedures

Excel VBA Topic 7.3 - Do While & Do Until loops

Two-Hour Excel VBA Absolute Beginner Course (Part 3/2)

Excel VBA Topic 5.2 - Customized Worksheet Functions