Home & Office Computing

11 Items

Sort by Date | Title

The Next Step Beyond the Macro Recorder in VBA Programming Jan 5, 2016 Don’t rely solely on the macro recorder to teach you VBA programming; it’s meant only as an introduction, and you can’t rely on it for more advanced programming methods. Tracy Syrstad, co-author of Excel 2016 VBA and Macros, provides 10 macro recorder tips that will take your VBA programming skills up a level or two.

Excel 2016 VBA and Macros: Referring to Ranges Dec 11, 2015 This chapter from Excel 2016 VBA and Macros shows you different ways of referring to ranges, such as specifying a row or column. You’ll also find out how to manipulate cells based on the active cell and how to create a new range from overlapping ranges.

Customizing Excel 2016 Dec 9, 2015 This chapter from Excel 2016 In Depth walks you through examples of customizing the ribbon and discusses some of the important option settings available in Excel.

Keep Your Web Surfing History Private when Using Safari on the iPhone/iPad Apr 23, 2014 Jason R. Rich discusses ways to keep your web surfing history and activities private when using the Safari browser on your iOS mobile device. Meanwhile, you can reverse some of the information offered within this article to keep close tabs on the web surfing activities of your kids.

Getting Data onto a Sheet in Excel 2013 By Tracy Syrstad May 13, 2013 This chapter provides tricks for copying down data, fixing entered data, and helping your users enter data correctly by providing a predefined list of entries for Excel 2013 users.

Customizing an Excel 2013 Pivot Table Mar 12, 2013 This chapter covers six functional areas in making pivot table customization: Minor Cosmetic Changes, Layout Changes, Major Cosmetic Changes, Summary Calculations, Advanced Calculations, and Other (less common) Options.

Advanced Windows Debugging: Memory Corruption Part II—Heaps Nov 9, 2007 This chapter discuss security vulnerabilities and stability issues that can surface in an application when the heap is used in a nonconventional fashion.

The Secret Life of GetWindowText Oct 5, 2007 Raymond Chen describes the the history of this oft-maligned function.

Will Cell Phones be Responsible for the Next Internet Worm? Apr 28, 2006 The mobile devices you know and love are great for productivity, but they have completely changed the vulnerability state of our networks. Norm Laudermilch tells you why you should be afraid, very afraid.

Creating User Feedback Forms Dec 23, 2003 Communicating with users is necessary if you want to create exciting applications that perform useful tasks. John Mueller discusses and demonstrates effective communication techniques to get constructive feedback that can keep you in touch with user needs.

Building Windows Applications in VB.NET Dec 5, 2003 In Visual Basic .NET, the technologies that enable you to create "standard" windows applications are part of the .NET Framework, available to any .NET language. This is a huge change from earlier versions of Visual Basic. Learn what's different -- and how you can take advantage of it.