Label Captions

If you've ever needed to insert line breaks in a message box prompt, you most likely built a string that incorporated a line feed or carriage return character. Unfortunately, label objects aren't as forgiving when it comes to using these characters.

If you're setting a label's Caption property with code, you'll find that the special control characters are interpreted as squares, since they're otherwise un-displayable.

To successfully insert a line break in a label caption, you need to include both a line feed character and a carriage return character, entered consecutively.

To do so, you can use the Chr() function, such as:

Me.Label1.Caption = "Line 1" & _
Chr(13) & Chr(10) & "Line 2"

Me.Label1.Caption = "Line 1" & vbCrLf & "Line 2"

Labels: Customize, General, Reference, Tips, VBA

A range of expressions

See the screen shots and download the free workbook:
Images to Excel

Excel 2003



This picture covers a range of A1:BL74, 4,736 cells, viewed at 15% zoom.

Excel 2007-10



This picture covers a range of A1:GR300, 60,000 cells, viewed at 10% zoom.



See all Topics excel

Labels: Addins, General, Graphics, Tips

2007 choices

Office 2007 uses OfficeArt to format text boxes, graphics and pictures.

It's available in Word, Excel , and PowerPoint, but it is most active in PowerPoint and Excel.

Here's a description:

Office PPT Art


See all Topics excel

Labels: Customize, Formats, General, Graphics, Tips, Tutorials

Excel reading

Labels: General, Link, Reference, Shortcuts, Tips, Tutorials

More flexibility

Lots of limits have been changed with 2007. The size of a worksheet is now 1,048,576 rows by 16,384 columns. The number of undo levels has gone up to 100.

Here are some more changes:

• Worksheet and workbook specifications and limits
  
  
• Calculation specifications and limits
  
  
• Charting specifications and limits
  
  
• PivotTable and PivotChart report specifications and limits
  
  
• Shared workbook specifications and limits

Labels: 2007, 2010, General, Reference

Level talk

1. Close any programs that are running.
   
   
2. Click Start, click Run, type regedit in the Open box, and then click OK.
   
   
3. In Registry Editor, expand one of the following registry subkeys, as appropriate for the version of Excel that you are running:
   
   Microsoft Office Excel 2010
   

   HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options

   
   Microsoft Office Excel 2007 uses Office\12.0\
   Microsoft Office Excel 2003 uses Office\11.0\
   Microsoft Excel 2002 uses Office\10.0\
   Microsoft Excel 2000 uses Office\9.0\
   
   
4. On the Edit menu, point to New, and then click DWORD Value. Select New Value #1, type UndoHistory, and then press ENTER.
   
   
5. On the Edit menu, click Modify.
   
   
6. In the Edit DWORD Value dialog box, click Decimal under Base. Type a value between 0 and 100 in the Value box, click OK, and then exit Registry Editor.
   
   
7. Start Excel. Excel stores an undo history for the number of actions that you specified in step 6.

Sub ClearUndo()
Range("A1").Copy Range("A1")
End Sub

Labels: Customize, General, Reference, Tips, Tutorials, VBA