Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1283
  • Last Modified:

Wrap Text in Excel through VBA

How could i have Wrap Text feature while fulfilling text in Excel Cell through piece of VB code.
0
srikanthv2322
Asked:
srikanthv2322
2 Solutions
 
RobSampsonCommented:
Hi, the WrapText property can be set on the ActiveCell using
ActiveCell.WrapText = True

Regards,

Rob.
0
 
nutschCommented:
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
 
TracyVBA DeveloperCommented:
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now