Hello All,
I have a program where I add all errors to a combobox using the addItem method. Sometimes there are quite a few and I would like to have them printed to paper. (Say via a commandbutton_click event).
Is there any way to do this without having to add the list of errors into a Word or Notepad or Excel document and then printing it
For us oldies, I guess I am asking if there is an equivalent of the old LPRINT command there used to be in in BASIC.
Cheers
Chas
Printing comboBox Items
ShadowRayz
Hi,
There is no "direct" print command for VBA to print to printer directly.
However, as you already add the error item to a combo box, you don't you just add the error to the spreadsheet and then use the ActiveSheet.PrintOut method to print the stuff directly
GregMaxey
Thanks PSHK,
I am using Word and will use that. I won't mark the post as "answered" yet as I may get some other ideas.
Chas
jaime.rq
Sorry,
I should have mentioned that these errors are not program errors but processing errors. They are expected and there will always be some (nearly always) usually due to missing data.
Chas