Search:

Results 1 to 10 of 20 |

Excel VBA / by McGrath, Mike,1952-author.;
Excel VBA in easy steps neatly demonstrates VBA (Visual Basic for Applications) Macro programming in a clear and concise manner, so you can get more from the popular Microsoft Excel spreadsheet application. Areas covered include: *Recording and editing Macros *Creating your own Macro programs *Coding with the VBA language *Responding to Worksheet events *Programming Excel procedures *Making 'DataForms' for data editing *Producing 'UserForms' for data entry *Displaying dynamic Charts *Sharing your Excel apps to impress your colleagues! Whether you're upgrading to Excel 2019, exploring Excel in the Office 365 suite, or new to the Macro programming concept, use this guide to learn the key features constructively and get more out of Microsoft Excel - in easy steps!
Subjects: Microsoft Excel (Computer file); Visual Basic for Applications (Computer program language); Electronic spreadsheets.;
Available copies: 1 / Total copies: 1
unAPI

Mastering VBA for Microsoft Office 365 / by Mansfield, Richard,1945-author.(CARDINAL)732687;
"The revised 2019 edition of Mastering VBA Microsoft Office 365 offers an accessible guide that shows how to extend the capabilities of Office 365 applications with VBA programming. Written in clear terms and understandable language, the book includes systematic tutorials and contains both intermediate and advanced content for experienced VB developers. Designed to be comprehensive, the book addresses not just one Office application, but the entire Office suite. To enhance understanding, the content is explored in real-world projects in Word, Excel, Outlook, and PowerPoint."--Amazon.com.
Subjects: Microsoft Office.; Visual Basic for Applications (Computer program language); Integrated software.; Business;
Available copies: 0 / Total copies: 1
unAPI

Excel VBA Programming : for Dummies / by Walkenbach, John,author.(CARDINAL)205411;
Take your data analysis and Excel programming skills to new heights In order to take Excel to the next level, you need to understand and implement the power of Visual Basic for Applications (VBA).
Subjects: Microsoft Excel (Computer file); Visual Basic for Applications (Computer program language); Electronic spreadsheets.; Business;
Available copies: 2 / Total copies: 2
unAPI

Excel VBA in easy steps / by McGrath, Mike,1956-author.(CARDINAL)422694;
Getting started -- Writing macros -- Storing values -- Performing operations -- Making statements -- Executing procedures -- Employing functions 101 -- Recognizing events -- Opening dialogs -- Providing UserForm dialogs -- Developing apps
Subjects: Microsoft Excel (Computer file); Visual Basic for Applications (Computer program language); Electronic spreadsheets; Electronic spreadsheets.; Business;
Available copies: 2 / Total copies: 3
unAPI

Excel VBA programming / by Kusleika, Dick,author.(CARDINAL)609555;
Starting Excel VBA programming. Getting to know VBA ; Building simple macros -- Employing VBA with Excel. Working in the Visual Basic Editor ; Introducing the Excel object model ; VBA sub and function procedures ; Using the Excel macro recorder -- Programming concepts. Essential VBA language elements ; Working with range objects ; Using VBA and worksheet functions ; Controlling program flow and making decisions ; Automatic procedures and events ; Error-handling techniques ; Bug extermination techniques ; VBA programming examples -- Communicating with your users. Simple dialog boxes ; UserForm basics ; Using UserForm controls ; UserForm techniques and tricks ; Accessing your macros through the user interface -- Putting it all together. Creating worksheet functions ; Creating Excel add-ins -- The part of tens. Ten handy Visual Basic Editor tips ; Resurces for VBA help ; Ten VBA do's and don'ts."Find out what Excel is capable of with this step-by-step guide to VBA. Short of changing the tires on your car, Microsoft Excel can do pretty much anything. And the possibilities are even more endless when you learn to program with Excel Visual Basic for Applications (VBA). Regardless of your familiarity with Excel VBA, Excel VBA Programming For Dummies can enhance your experience with the popular spreadsheet software. Pretty soon, you'll be doing things you didn't think were possible in Excel, from automating processes to writing your own worksheet functions. You'll learn how to: Understand the basic tools and operations of Visual Basic for Applications; Create custom spreadsheet functions that make life easier for you and the people maintaining your spreadsheets; Deal with errors and exceptions and eliminate the bugs in your code. Perfect for anyone who's never even heard of Excel VBA, Excel VBA Programming For Dummies is also a fantastic resource for intermediate and advanced Excel users looking for a heads-up on the latest features and newest functionality of this simple yet powerful scripting language"--Publisher's description.
Subjects: Instructional and educational works.; Handbooks and manuals.; Microsoft Excel (Computer file); Visual Basic for Applications (Computer program language); Electronic spreadsheets.; Business; Tableurs.;
Available copies: 3 / Total copies: 3
unAPI

Microsoft 365 Excel VBA programming / by Kusleika, Dick,author.(CARDINAL)609555;
Introduction -- PART 1: Starting Excel VBA programming. Getting to know VBA ; Building simple macros -- PART 2: Using VBA with Excel. Working in the visual basic editor ; Introducing the Excel object model ; VBA sub and function procedures -- PART 3: Creating code automatically. Using the Excel macro recorder ; Generating code with Copilot -- PART 4: Programming concepts. Essential VBA language elements ; Working with range objects ; Using VBA and worksheet functions ; Controlling program flow and making decisions ; Automatic procedures and events ; Error-handling techniques ; Bug extermination techniques ; VBA programming examples -- PART 5: Communicating with your users. Simple dialog boxes ; UserForm basics ; Using UserForm controls ; UserForm techniques and tricks ; Accessing your macros through the user interface -- PART 6: Putting it all together. Creating worksheet functions ; Creating Excel add-ins -- PART 7: The part of tens. Ten handy visual basic editor tips ; Resources for VBA help ; Ten VBA do's and don'ts."Fully updated for the latest version of Office 365, Excel VBA Programming For Dummies will take your Excel knowledge to the next level. With a little background in Visual Basic for Applications (VBA) programming, you can go well beyond basic spreadsheets and functions. Learn the coding basics and syntax you need to write simple or complex macros that can automate your routine Excel tasks. Become an Excel power user by automating data management, user forms, pivot tables, and beyond. When you use VBA to perform Excel operations, you can reduce errors, save time, and integrate with other Microsoft applications. This handy guide also teaches you how to control the security settings for your macros and save macros to use across files and apps. Plus, you'll get updated coverage of Copilot AI integration. Your spreadsheets are about to get much more powerful. " --
Subjects: self-instructional materials.; handbooks.; Self-instructional works.; Handbooks and manuals.; Matériel d'auto-enseignement.; Guides et manuels.; Microsoft Excel (Computer file); Visual Basic for Applications (Computer program language); Electronic spreadsheets.; Business; Tableurs.; COMPUTERS / Programming / Microsoft Programming.; COMPUTERS / Business & Productivity Software / Spreadsheets.; COMPUTERS / Business & Productivity Software / Office Suites.;
Available copies: 2 / Total copies: 2
unAPI

Excel VBA 24-hour trainer / by Urtis, Tom,author.(DLC)no2011077111;
Presents information on using Microsoft's Visual Basic for Applications (VBA) programming language to customize the spreadsheet program Excel.
Subjects: Microsoft Excel (Computer file); Microsoft Visual Basic for applications.; Electronic spreadsheets.; Business;
Available copies: 1 / Total copies: 1
unAPI

Beginning Visual Basic 2012 / by Newsome, Bryan,1971-(CARDINAL)472175;
"Using the time-tested Wrox approach, this guide provides a step-by-step format that gets beginners up and running quickly and confidently. Essential topics covered include writing Windows applications, working with dialog boxes and menus, object oriented programming techniques, programming for graphics, using Visual Basic with ASP.NET for web apps, and dealing with data access and SQL Server."--Publisher.
Subjects: BASIC (Computer program language); Visual Basic (Computer program language);
Available copies: 1 / Total copies: 1
unAPI

Murach's Visual Basic 2012 : training & reference / by Boehm, Anne,author.(CARDINAL)549608;
Introduction to Visual Basic programming -- The Visual Basic language essentials -- Database programming -- Object-oriented programming -- More skills for working with data -- Enhancement, deployment, and Windows 8 -- Reference aids.This 5th Edition of Murach's Visual Basic shows how to use Visual Studio 2012, VB 2012, and the .NET 4.5 classes to develop Windows Forms applications; prototype professional database applications using RAD features like data sources; use ADO.NET to work directly with databases for more control, use LINQ to query a variety of data sources, from databases to arrays to XML files; how to use business classes, inheritance, and interfaces the way they're used in the real world; and how to develop your first Windows 8 apps and submit them to the Windows Store.
Subjects: Microsoft .NET Framework.; BASIC (Computer program language); Object-oriented programming (Computer science); Visual Basic (Computer program language);
Available copies: 1 / Total copies: 1
unAPI

Sams teach yourself Visual Basic 2012 in 24 hours / by Foxall, James D.(CARDINAL)638995;
The Visual Basic 2012 environment. Jumping in with both feet: a Visual Basic 2012 programming tour. Navigating Visual Basic 2012 -- Understanding objects and collections -- Understanding events -- Building a user interface. Building forms: the basics -- Building forms: advanced techniques -- Working with traditional controls -- Using advanced controls -- Adding menus and toolbars to forms -- Making things happen--programming. Creating and calling code procedures -- Using constants, data types, variables, and arrays -- Performing arithmetic, string manipulation, and date/time adjustments -- Making decision in Visual Basic code -- Looping for efficiency -- Debugging your code -- Designing objects using classes -- Interacting with users -- Working with graphics -- Working with data. Performing file operations -- Working with the registry and text files -- Working with a database -- Controlling other applications using automation -- Deploying solutions and beyond. Deploying applications -- The 10,000-foot view."User level: Beginning-intermediate"--P. [4] of cover.
Subjects: Microsoft .NET Framework.; Visual Basic (Computer program language); BASIC (Computer program language);
Available copies: 1 / Total copies: 1
unAPI

Results 1 to 10 of 20 |