Solved

Wrap Text in Excel through VBA

Posted on 2011-02-27
4
1,194 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
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VMWare Calculate number of processors 10 64
Limit the # times a macro code will run 14 50
get the ALL CAPITAL words from a cell 4 19
Collapse and expand table in Word 2010 2 32
Over the years I have built up my own little library of code snippets that I refer to when programming or writing a script.  Many of these have come from the web or adaptations from snippets I find on the Web.  Periodically I add to them when I come…
Not long ago I saw a question in the VB Script forum that I thought would not take much time. You can read that question (Question ID  (http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_28455246.html)28455246) Here (http…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

856 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