Highlight list header and Wrap the text in ListBox

Posted on 2010-01-04
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
    LVL 12

    Expert Comment

    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

    Hi sstampf,

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

    Author Comment

    Hi sstampf,

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

    Accepted Solution

    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

    Hi sstampf,

    Thanks for your help in finding a workaround process.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    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…
    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
    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.

    794 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now