Macro

How To : Enter formulas in Excel with a macro

In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, d ...more

How To : Clear data & cell contents in Excel using a macro

In order to clear the cell content in Excel, using a macro, you will first need to have a table. If you don't already have a spreadsheet, you will need to create one with random numbers. Next, highlight some numbers, by clicking one box and dragging in order to select a number ...more

News : Easy! Cell Phone Camera Macro Mod (5X Zoom)

Hack N Mod offers an incredibly simple cell phone camera mod that delivers striking results. All you need is a lens from an old DVD player and you can magnify your zoom by five times. "You’ll find the lens directly under the disk tray. If you’ve just upgraded to Blu-Ray, now ...more

News : 3 Ultra-Cheap DIY Macro Photography Hacks

Giveaway Tuesdays has officially ended! But don't sweat it, WonderHowTo has another World that's taken its place. Every Tuesday, Phone Snap! invites you to show off your cell phone photography skills. Submit your best shot to our weekly competition for a chance to win an awes ...more

How To : Learn extreme macro photography tricks

Watch this quick instructional photography video and discover how to do extreme macro photography without having any real specialized macro photo equipment. Use a couple of your existing lenses to create a super macro lens. Practice these tips and improve your photography skills.

How To : Run an existing macro in Microsoft Excel 2011

Can't quite figure out how to run a macro when using Microsoft Excel 2011 on your Mac? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the funda ...more

HowTo : Build Your Own DIY SuperMacro Lens

Lozzless demonstrates how to make a diy cheap macro lens with working aperture for his Canon 5D Mark II, coined the "SuperMacro". According to Hack a Day, "The process involves fashioning a connector ring from a lens cap, modifying an Electro-focus lens mount, and assembling ...more

How To : Enable macros in Excel to run correct spreadsheets

The Costsheet demonstrates how to enable macros in Excel 2007 to run correct spreadsheets. First, open up the spreadsheet. Make sure that the macros are enabled. If they have not, enable the macros by placing them in a trusted source by saving them in a particular folder. You ...more

News : The Money Making Macro

In Google definitions a macro is defined as "a single computer instruction that results in a series of instructions in machine language". Basically a macro is a programming script that tells the computer what to do. You can tell a computer (via a macro) to move a mouse, click, ...more

How To : Use macro and advanced filters in Microsoft Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use Advanced Fi ...more

How To : Create a message box in MS Access with a macro

The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll ...more

HowTo : Build Your Own DIY SuperMacro Lens

Via WonderHowTo World, Cinematography: Lozzless demonstrates how to make a diy cheap macro lens with working aperture for his Canon 5D Mark II, coined the "SuperMacro". According to Hack a Day, "The process involves fashioning a connector ring from a lens cap, modifying an ...more

How To : Dump data from an Excel pivot table with a macro

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 229th installment in their series of digital spreadsheet magic tricks, you'll learn how to dump da ...more

How To : Record macros on a Microsoft Windows PC with AutoHotKey

In this clip, you'll learn how to create custom macros on a Microsoft Windows desktop or laptop computer with AutoHotKey. For more information, including a complete demonstration of the process and detailed, step-by-step instructions, watch this home-computing how-to from PCMech.

How To : Check if a cell is empty using macros in Excel

Microsoft Excel is used to store and work on data by storing them in rows and columns in tables. You can use a macros to check if a cell is empty. To do this you have to know two short cuts. The first is the VBA Window short cut which is Alt + F11 and the other one is View Mac ...more

How To : Use macros in Microsoft Excel 2007

Looking for an introduction on how to work with macros in Microsoft Excel 2007? Learn how to create linkage formulas in MS Excel 2007. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself ...more

HowTo : Make a 50¢ Macro Lens

Forget splurging on a fancy digital camera. All you need to do is attach a lens from a pair of dollar store reading glasses, and you'll get your macro shot. From Sean Lee, how to make a fifty cent macro lens. Before After Previously, Easy! Cell Phone Camera Macro Mod (5X Zo ...more

How To : Shoot close-up shots with a macro lens

In this lesson, learn how to shoot compelling close-up shots using a macro lens. Tips on composition, lighting and controlling depth of field are discussed in detail. Watch this video photography tutorial and learn how to shoot close-up pictures with a macro lens.

How To : Shoot macro photography on a budget

Create your own macro lens using the standard 50 mm lens that is shipped with your Digital SLR camera. The presenter - Kip Kay explains how to do so in a very cost effective way using only a Pringles( or any other similar) can, a black cloth, your camera's body cap and a few ...more

HowTo : The $5 iPhone Macro Mod

Crabfu demonstrates how to mod your iPhone with a microscope for just $5 (UPDATE: the $5 microscope from Amazon is now selling it for $12.50... read more). Incredibly simple to make! Check out the sample images taken below the video. Gears on the Kinekt Gear Ring. $20 Bill . ...more

How To : Max people with macros on YoVille (10/01/09)

How to hack Yoville! Yoville cheats, tricks, hacks. Watch this video tutorial to learn how to max people with macros on YoVille (10/01/09). Maxing people with keyboard macros! One shortcut clicks the "Accept" button on the left side where it won't be obscured by the RPS wind ...more

How To : Record macros in Excel 2007

In this Microsoft Excel 2007 for Dummies video the instructor shows how to record a Macro. Macros let you create a shortcut to perform a sequence of commands all at once. For example you can create a macro to quickly build a sales report template that you frequently use. When ...more

How To : Remove the macro warning in Excel

In this video tutorial, viewers learn how to remove the macro warning in Microsoft Excel. When you see the warning, click Enable Macros. Then right-click on of the sheet tabs and select View Code. Open the Modules folder menu. Now right-click on the module and select Remove Mo ...more

My Father's Garden : Awe Inspiring Macro Footage

Amazing what you can get out of camcorder these days. "Discovering a whole tiny world in my father's small garden. There is a small pond with small falls, some stones, some plants, and plenty of life! Shot on Panasonic 500- Fujinon 17x7.6 HD lens." Video: Use the Panasonic HP ...more

News : $2500 Camera Wows Planet Earth Quality Macros

Insekten!, test shots using Canon macro lenses and the Canon 5D Mark II, by YouTube user Powermaennchen.  Incredible footage for a $2500 digital camera. I'm willing to bet Planet Earth used cameras that were a bit more expensive than $2500... Have a Canon 5D Mark II or thinki ...more

How To : Manually Control Aperture with Macro Extension Rings

Macro extension rings are an affordable solution to buying expensive macro lenses, but there is no way to control the aperture when using macro extension tubes without contacts. However, by utilizing a piece of paper, you can easily control the aperture. Video: .

How To : Focus stack for great macro photos

In this Fine Art video tutorial you will learn how to focus stack for great macro photos. This video is from EPhotoZine. The idea is to take several pictures of the same subject at different distances. For this you will need focus stacking. If you focus with a wide aperture, e ...more

How To : Write a macro by hand in Excel for beginners

The speaker in this video introduces the concept of macros used in Excel, very simply and lucidly. Two sets of shortcut keys are used, one set to create the macro and the other set to run it. The first shortcut opens up the VBA window (Alt+F11), with a workbook along with the ...more

How To : Use the macro mode on your digital camera

The macro mode on a camera can be baffling. What's it for? Well, if you've got something small and pretty to shoot, like a butterfly, macro gives you the best shot possible. It's also good for taking pictures of things that are small and ugly, like scratches in your car paint. ...more

How To : Record custom macros in Microsoft Excel 2007

Want to record your own custom macros within MS Excel 2007? See how it's done. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to ...more

How To : Do macro photography shots for beginners

Macro photography is a type of photography used to create interest by focusing the lense on one thing in a picture, generally something that's located in the foreground. The rest of the image (the midground and background) fades out into a blur. This is a special effect that ...more

How To : Shoot Macro Video

The advantage of the camcorder is that sometimes, it can see more than the human eye when put close up to something. This cinematography video should help you make interesting shots as well as get really good extreme close-ups.

How To : Shoot close-ups in macro mode, For Dummies

From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. This is Digital Photography for Dummies. Just watch this video tutorial to learn how to shoot close-ups in macro mode, For Dummies. Digital camera ...more

How To : Use macro security options in Excel 2007

Some times when you upgrade your Microsoft Excel software to Excel 2007 your old macros may stop working. Some times this may be due to the settings and by enabling the macros you can get your old macros to work. Macros are turn off by default in Excel 2007. You can turn this ...more

Prev Page
  • Hot
  • Latest