VBA - Text in a cell with line break
Solved
steph
-
lermite222 Posted messages 9042 Status Contributor -
lermite222 Posted messages 9042 Status Contributor -
Hello,
In a spreadsheet, I have a column that indicates the type of stock for the product, knowing that there are a total of 3 different types: consignment, white label A, white label B.
I would like to summarize this in a single cell. Ideally, I want a cell that includes:
- Consignment: X
- White label A: Y
- White label B: Z
Where X, Y, and Z are the percentages of "consignment" in the column and so on.
Thank you in advance for your valuable help!
Steph
In a spreadsheet, I have a column that indicates the type of stock for the product, knowing that there are a total of 3 different types: consignment, white label A, white label B.
I would like to summarize this in a single cell. Ideally, I want a cell that includes:
- Consignment: X
- White label A: Y
- White label B: Z
Where X, Y, and Z are the percentages of "consignment" in the column and so on.
Thank you in advance for your valuable help!
Steph
2 answers
-
Hello,
Range("A2").WrapText = True Range("A2") = "Consignment: X " & Chr(10) & "White label A: Y" & Chr(10) & "White label B: Z "
A+
--
If you bump into a pot and it sounds hollow, it's not necessarily the pot that's empty. ;-)(Confucius)
Note: I do not respond to PMs for technical questions. And my crystal ball is broken. -
