I am trying to print out listbox1 and it's contents, but can not find anything anywhere on the subject.
Can it be done?
I am trying to print out listbox1 and it's contents, but can not find anything anywhere on the subject.
Can it be done?
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks