Re: There should be a shortcut icon for "wrap text"

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Dave

That's just lazy ;-)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@xxxxxxxxxxxxxxxxx


"Dave Peterson" <ec35720@xxxxxxxxxxxxxxxxx> wrote in message
news:425F0D32.F25375DB@xxxxxxxxxxxxxxxxxxxx
> And one more option:
>
> Sub Wrap_Text2()
> Selection.WrapText = not activecell.wraptext
> End Sub
>
>
>
> Terri@Lear wrote:
>>
>> There is an icon for almost every other formatting function, and wrap
>> text is
>> one I use continually, but there's no shortcut and it takes several steps
>> each time.
>
> --
>
> Dave Peterson


.



Relevant Pages

  • Re: How to edit row height with conditional formatting?
    ... Private Sub Worksheet_Change ... Microsoft MVP - Excel ... >> Southampton, England ...
    (microsoft.public.excel.misc)
  • RE: Editing MSExcel worksheet in MSWord file
    ... Super-Easy Guide to the Microsoft Office Excel 2003 Object Model ... Learn how easy it is to use the Excel object model to customize ... Lesson 2:Programming Concepts: Sub. ...
    (microsoft.public.vb.general.discussion)
  • =?Utf-8?Q?RE:_Referenzwerte_einer_Pivot-Ta?= =?Utf-8?Q?belle_in_Excel_von_VB.2003_aus_=C
    ... Private Sub Worksheet_Activate ... Ich bin leider kein Excel Profi und habe auch noch nicht mit Pivot Tabellen ... Library" gesetzt hast und die Deklaration für myXL und myWS vorgenommen hast, ...
    (microsoft.public.de.german.entwickler.dotnet.vb)
  • Re: VBA in module vs slide
    ... Sub GetName() ... command button and put that on a slide and put the following in the slide ... Dim oAppXL As Object 'Declare the Excel application object ... .Offset.Value = strUserEmpNo ...
    (microsoft.public.powerpoint)
  • Re: Fun with Userforms!!!!
    ... the userframe to still remain visible even if Excel is minimized ... It's a Userfrom, it's always a Userform. ... Private Sub Workbook_SheetActivate ...
    (microsoft.public.excel.programming)