• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 313
  • Last Modified:

Highlight list header and Wrap the text in ListBox

Hi Experts,

I would like to request Experts help to highlight list header (fill color) in detail view and also wrap the text. Ive no idea how to do this.  Ive attached the .xls file for your perusal.  

Database: No password required, just click "OK"
CMR-Activity-2010-Master--List-N.xls
0
Theva
Asked:
Theva
  • 3
  • 2
1 Solution
 
sstampfCommented:
So if I am getting you correctly, you want to color the header in sheet "CRM Datasheet" and also do a text wrap. Is it true?
0
 
ThevaAuthor Commented:
Hi sstampf,

Not on the "CRM Datasheet" but the "Detail View"(ListBox1) in the userform1.
0
 
ThevaAuthor Commented:
Hi sstampf,

Hope my explanation is clear, please do let me know if you need further clarification.
0
 
sstampfCommented:
I tried finding a solution for you but I don't think that using ListBox you can acheive these kind of formatting changes. I am proposing a workaround. I have modified your Form in the file attached below. I have populated just few "Cells" to act as example. Using this approach you can format the headers as well as do a text wrap (I have inserted a scrollbar which you can use to see all of the text).
Regards
Shashank

CMR-Activity-Modified.xls
0
 
ThevaAuthor Commented:
Hi sstampf,

Thanks for your help in finding a workaround process.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

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