Printform has stopped working..

[Tom Archer]

Hi,

I've been writing vba code in a very amateur capacity for 25 years and have created various applications along the way. Some of these make use of the Printform tool to print out data displayed on a userform.

However, whilst it appears to go through the motions (the little print dialogue box flashes up for a second or so) it has stopped printing them.

There is nothing lurking in the print queue, and when I use the conventional print command to print out part of the spreadsheet, that works fine.

I still use Excel 2003 (on Windows 10) as the newer version drove me insane, and everything else still seems to work fine. Restarting the PC did not solve matters.

- Anyone have any ideas as to what the cause of this might be?

[AliGW]

Welcome to the forum.

You have mistakenly told us your Windows version in the MS Office version field in your user profile - please go back and change this. Thanks.

[Tom Archer]

Oops - sorted..

[AliGW]

Can you post the section of code that relates to this? You are using an old version, and it may be that your version of Windows now won't understand the code you've used - maybe a Windows update has deprecated it.

[Tom Archer]

This is a typical bit of code - the PrintForm method normally works fine without specifying the object,
but even when I add that, it's still refusing to work..

Please Login or Register  to view this content.

[AliGW]

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new here, I have added them for you this time.)