Select one of the toolbars and right-click. Select Customize, and then select the Commands tab. From Tools, select Camera, and drag the icon to the toolbar. Click Close.

Select a cell or range in the sheet. Click the Camera icon, and select a cell in a different sheet or open workbook. Click the cell to create the object.

Use of the Camera is limited. You can only view calculation results or the data in a defined range of cells.

• Create User Forms in Microsoft Excel
• Using Loops in VBA in Microsoft Excel
• The Best Shortcut Keys in Microsoft Excel
• Writing Your First VBA Function in Excel
• Add Combo Box to a Sheet in Microsoft Excel
• Formulas to calculate Loan payments in Microsoft Excel
• Array variables using VBA in Microsoft Excel
• Create an Amortization Schedule in Microsoft Excel
• Find duplicates items in combine columns in Microsoft Excel
• Vlookup Formula – Organizing the Data Table