Highlight list header and Wrap the text in ListBox

Posted on 2010-01-04
Medium Priority
Last Modified: 2012-08-14
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"
Question by:Theva
  • 3
  • 2
LVL 12

Expert Comment

ID: 26178927
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?

Author Comment

ID: 26178966
Hi sstampf,

Not on the "CRM Datasheet" but the "Detail View"(ListBox1) in the userform1.

Author Comment

ID: 26180617
Hi sstampf,

Hope my explanation is clear, please do let me know if you need further clarification.
LVL 12

Accepted Solution

sstampf earned 1500 total points
ID: 26189490
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).


Author Closing Comment

ID: 31672766
Hi sstampf,

Thanks for your help in finding a workaround process.

Featured Post

Industry Leaders: 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!

Question has a verified solution.

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

With User Account Control (UAC) enabled in Windows 7, one needs to open an elevated Command Prompt in order to run scripts under administrative privileges. Although the elevated Command Prompt accomplishes the task, the question How to run as script…
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

864 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