+ Reply to Thread
Results 1 to 3 of 3

Resizing First Collum in a Multi Collum Listbox

  1. #1
    Registered User
    Join Date
    09-18-2013
    Location
    ENgland
    MS-Off Ver
    Excel 2013
    Posts
    62

    Resizing First Collum in a Multi Collum Listbox

    Hello am having a little trouble with my form listbox will upload a screen shot and hopefully someone will be able to point me in the right direction

    PatternsA.jpg

    I have Populated my listbox with


    Please Login or Register  to view this content.

    I want to make the first collum in the list box alot smaller so the numbers are not so far away from collum 2, any help would be greatly apreciated :D

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Resizing First Collum in a Multi Collum Listbox

    .ColumnWidths i think, not in excel at the minute
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Registered User
    Join Date
    09-18-2013
    Location
    ENgland
    MS-Off Ver
    Excel 2013
    Posts
    62

    Re: Resizing First Collum in a Multi Collum Listbox

    thanks for the pointer managed to get it working by changing the collum width to 20 pt;30 pt ! wehey thanks alot =]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Collum Delete Macro Needs to run twice to do it's job!?
    By exarranum in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-23-2013, 09:36 PM
  2. Extracting only non-zero values in a collum
    By bjkrukowski in forum Excel General
    Replies: 1
    Last Post: 10-04-2011, 12:29 PM
  3. How can I advanced sort into a Collum
    By Dan S in forum Excel General
    Replies: 3
    Last Post: 02-20-2006, 06:00 PM
  4. [SOLVED] Getteing the collum name
    By alvin Kuiper in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2006, 08:50 AM
  5. if negative then goes in collum b
    By justchris in forum Excel General
    Replies: 1
    Last Post: 01-27-2005, 08:52 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1