+ Reply to Thread
Results 1 to 3 of 3

Print A Listbox

  1. #1
    Registered User
    Join Date
    11-28-2003
    Posts
    39

    Print A Listbox

    I am trying to print out listbox1 and it's contents, but can not find anything anywhere on the subject.

    Can it be done?

  2. #2
    Registered User
    Join Date
    02-18-2005
    Posts
    26

    Wink

    create the following sub for a command button, it will write values onto sheets(1)

    For Each varList In <formname>.<listbox name>.List

    For Each rngCell in Sheets(1).Columns(1).Cells
    If rngCell = Empty Then
    rngCell.Value =varList
    Exit For
    End if
    Next rngCell
    Next varList


    cheers

  3. #3
    Registered User
    Join Date
    11-28-2003
    Posts
    39
    This code copies the listbos contents to column A on my worksheet.

    Do i then have to print the worksheet cells?

    PS: the listbox contains two colums of data. Can this be copied to say comumns A & B

    Also will it over write - because looking at the code it will only copy if the cell is empty. If so how would i copy new listbox data across to be printed?
    Last edited by mikewild2000; 04-12-2005 at 06:41 PM. Reason: added a bit extra

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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