Solved

Wrap Text in Excel through VBA

Posted on 2011-02-27
4
1,210 Views
Last Modified: 2012-06-21
How could i have Wrap Text feature while fulfilling text in Excel Cell through piece of VB code.
0
Comment
Question by:srikanthv2322
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 65

Accepted Solution

by:
RobSampson earned 250 total points
ID: 34993636
Hi, the WrapText property can be set on the ActiveCell using
ActiveCell.WrapText = True

Regards,

Rob.
0
 
LVL 39

Assisted Solution

by:nutsch
nutsch earned 250 total points
ID: 34997560
And to do a return in filling a cell via vba, you can use vbcrlf or chr(10), as in

[a1].value="string" & vbcrlf & "string 2"

Thomas
0
 
LVL 24

Expert Comment

by:broomee9
ID: 35225367
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question