Michael Alexander: Excel 2019 Power Programming with VBA

453 449

454 450

455 451

456 452

457 453

458 454

459 455

460 456

461 457

462 458

463 459

464 460

465 461

466 462

467 463

468 464

469 465

470 466

471 467

472 468

473 469

474 470

475 471

476 472

477 473

478 474

479 475

480 476

481 477

482 478

483 479

484 480

485 481

486 482

487 483

488 484

489 485

490 486

491 487

492 488

493 489

494 490

495 491

496 492

497 493

498 494

499 495

500 496

501 497

502 498

503 499

504 500

505 501

506 502

507 503

508 504

509 505

510 506

511 507

512 508

513 509

514 510

515 511

516 512

517 513

518 514

519 515

520 516

521 517

522 518

523 519

524 520

525 521

526 522

527 523

528 524

529 525

530 526

531 527

532 528

533 529

534 530

535 531

536 532

537 533

538 534

539 535

540 536

541 537

542 538

543 539

544 540

545 541

546 542

547 543

548 544

549 545

550 546

551 547

552 548

553 549

554 550

555 551

556 552

557 553

558 554

559 555

560 556

561 557

562 558

563 559

564 560

565 561

566 562

567 563

568 564

569 565

570 566

571 567

572 569

573 570

574 571

575 572

576 573

577 574

578 575

579 576

580 577

581 578

582 579

583 580

584 581

585 582

586 583

587 584

588 585

589 586

590 587

591 588

592 589

593 590

594 591

595 592

596 593

597 594

598 595

599 596

600 597

601 599

602 600

603 601

604 602

605 603

606 604

607 605

608 606

609 607

610 608

611 609

612 610

613 611

614 612

615 613

616 614

617 615

618 616

619 617

620 618

621 619

622 620

623 621

624 622

625 623

626 624

627 625

628 626

629 627

630 628

631 629

632 630

633 631

634 632

635 633

636 634

637 635

638 637

639 638

640 639

641 640

642 641

643 642

644 643

645 644

646 645

647 646

648 647

649 648

650 649

651 650

652 651

653 652

654 653

655 654

656 655

657 656

658 657

659 659

660 660

661 661

662 662

663 663

664 664

665 665

666 666

667 667

668 668

669 669

670 670

671 671

672 672

673 673

674 674

675 675

676 676

677 677

678 678

679 679

680 680

681 681

682 682

683 683

684 684

685 685

686 686

687 687

688 688

689 689

690 690

691 691

692 692

693 693

694 694

695 695

696 696

697 697

698 698

699 699

700 700

701 701

702 702

703 703

704 704

705 705

706 706

707 707

708 708

709 709

710 710

711 711

712 713

713 715

714 716

715 717

716 718

717 719

718 720

719 721

720 722

721 723

722 725

723 726

724 727

725 728

726 729

727 730

728 731

729 732

730 733

731 734

732 735

733 736

734 737

735 738

736 739

737 740

738 741

739 742

Michael Alexander

Dick Kusleika

Previously by John Walkenbach

For most of us, the path to Excel VBA programming starts with the need to perform some task that can't be done with the standard tools in Excel. That task is different for each of us. Maybe that task is to create separate workbooks automatically for all the rows in a data set. Maybe that task is to automate the emailing of dozens of reports. Whatever that task is for you, you can bet that someone has started their own journey into Excel VBA with the same need.

The beautiful thing about Excel VBA is that you don't have to be an expert to start solving problems with it. You can learn just enough to solve a particular problem, or you can go further and discover ways to handle all kinds of automation scenarios.

Whatever your goals may be, Excel 2019 Power Programming with VBA will help you harness the power of the VBA language to automate tasks, work smarter, and be more productive.

This book focuses on Visual Basic for Applications (VBA), the programming language built into Excel (and other applications that make up Microsoft Office). More specifically, it shows you how to write programs that automate various tasks in Excel. This book covers everything from recording simple macros through creating sophisticated user-oriented applications and utilities.

You can approach this book in any way you please. You can read it from cover to cover, or you can skip around, picking up useful tidbits here and there. VBA programming is often a task-oriented endeavor. So, if you're faced with a challenging task, you might try the index first to see where the book might specifically address your problem.

This book does not cover Microsoft Visual Studio Tools for Office (VSTO), a technology that uses Visual Basic .NET and Microsoft Visual C#. VSTO can also be used to control Excel and other Microsoft Office applications.

As you may know, Excel 2019 is available for other platforms. For example, you can use Microsoft's Excel Web App in your browser and even iPads and tablets. These versions do not support VBA. In other words, this book is for the desktop version of Excel 2019 for Windows.

This is not a book for beginning Excel users. If you have no experience with Excel, a better choice might be the Excel 2019 Bible (Wiley, 2018), which provides comprehensive coverage of all the features of Excel and is meant for users of all levels.

To get the most out of this book, you should be a relatively experienced Excel user who knows how to do the following:

Create workbooks, insert sheets, save files, and so on

Navigate through a workbook

Use the Excel Ribbon user interface

Enter formulas

Use Excel's worksheet functions

Name cells and ranges

Use basic Windows features, such as file management techniques and the Clipboard

Excel is available in several versions, including a web version and a version for tablets and phones. This book was written exclusively for the desktop version of Microsoft Excel 2019 for Windows. If you plan to develop applications that will be used in earlier versions of Excel, we strongly suggest you use the earliest version of Excel that your target audience will be using. Over the last few years, Microsoft has adopted an agile release cycle for the web version of Excel with Office 365, generating release updates practically on a monthly basis.