Hi i'm doing a college project and ive just about finished but i need to be able to print the information thats in a textbox on a userform. I don't mind whether it prints the whole userform or even takes a screen shot if thats possible, but i need to be able to make a commandn button which prints the information in the textbox.

Any ideas?

thanks

Hi

Is this a form you created in the excel spreadsheet? If its in the spreadsheet you just need to add (e.g)

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

You add this code to the command button's onClick event. You could also link the textbox to a cell which you could select and use:

Selection.PrintOut Copies:=1, Collate:=True

This will then only print the data and not txtbox itself.

Is this what you are looking for?

Regards
Marnus

Yes that worked thankyou very much.