Re: Printing a User Form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Jan,

Absolutely brilliant - I just wrote the code not knowing that the command
button was on another sheet with your explanation of clicking twice on the
button in VBA it threw me on to the right sheet and code - just added
UserForm1.PrintForm in the correct place and it worked perfectly. Thank you
again

Regards

Mully

"Jan Karel Pieterse" wrote:

> Hi Mully,
>
> > find it difficult to write the necessary code to print the form when it
> > activates in excel - does this explanation help????
>
> What do you mean by "activates in Excel"?
>
> The code I gave you should be tied to a command button that is on the
> userform itself. You can access the code of a button (or any other
> control) from the VBE by double clicking the control in the userform's
> design window.
>
> Regards,
>
> Jan Karel Pieterse
> Excel MVP
> http://www.jkp-ads.com
>
>
.

Relevant Pages

  • Re: PLEASE I NEED YOUR HELP
    ... You will need to check if the data on the sheet is able to display a form ... Microsoft MVP - Excel ... > - But i need to create a command button to make a shourcut for this form ...
    (microsoft.public.excel.programming)
  • Re: Excel 2007 VBA - macro stops after autofilter command
    ... command, based on selections the user has made via a pop-up form. ... Previous to Excel 2007, this was working fine. ... command lines following the autofilter command are ignored. ... from the sheet, my code ran fine and continued on past the autofilter ...
    (microsoft.public.excel.programming)
  • Re: Excel 2007 VBA - macro stops after autofilter command
    ... command, based on selections the user has made via a pop-up form. ... Previous to Excel 2007, this was working fine. ... command lines following the autofilter command are ignored. ... from the sheet, my code ran fine and continued on past the autofilter ...
    (microsoft.public.excel.programming)
  • Re: hiding the worksheet
    ... And my Excel add-in "XL Extras" is one of those that do. ... It also provides an "Unhide All" command on the Format |Sheet menu. ... As a matter of fact I do have "Hide on my Sheet tab right click menu. ... Do you have a "Hide" command added to the sheet tab right-click menu? ...
    (microsoft.public.excel.misc)
  • Re: Organizing my freq used formulas/expressions
    ... Copy and stick in NotePad with an explanation of what they do. ... Gord Dibben MS Excel MVP ... formulas/functions/expressions that one frequently uses? ... The 2 expressions below did the same thing on my excel sheet and I will no ...
    (microsoft.public.excel.newusers)