Adding Objects to PrintDialog

Is there a way to add checkboxes, dropdown ect. to the printdialog, like
when i'm adding objects to a userform using code ?

I need to precent some reporttype-choises to the user when the print button
is pressed.

Hoping for a positive answer


Claus

Claus,
Using the PrintDialog API and hook/templates you can achieve it, but not
natively in VBA, AFAIK.

Easier would be to make your own userform with the options, then make those
changes to the WB and print it yourself.

NickHK

"Claus" <[email protected]> wrote in message
news:[email protected]...
> Is there a way to add checkboxes, dropdown ect. to the printdialog, like
> when i'm adding objects to a userform using code ?
>
> I need to precent some reporttype-choises to the user when the print
button
> is pressed.
>
> Hoping for a positive answer
>
>
> Claus
>
>

Nick,

I'm not a pro, though i did VBA on and off for some years.

Whats the PrintDialog API ?

If i'm to build a userform, how do i get the list of printers,
printerstatus, location and so on ?

Claus

"NickHK" <[email protected]> skrev i en meddelelse
news:[email protected]...
> Claus,
> Using the PrintDialog API and hook/templates you can achieve it, but not
> natively in VBA, AFAIK.
>
> Easier would be to make your own userform with the options, then make
> those
> changes to the WB and print it yourself.
>
> NickHK
>
> "Claus" <[email protected]> wrote in message
> news:[email protected]...
>> Is there a way to add checkboxes, dropdown ect. to the printdialog, like
>> when i'm adding objects to a userform using code ?
>>
>> I need to precent some reporttype-choises to the user when the print
> button
>> is pressed.
>>
>> Hoping for a positive answer
>>
>>
>> Claus
>>
>>
>
>

Claus,
Found this:
http://pubs.logicalexpressions.com/P...cle.asp?ID=183

NickHK

"Claus" <[email protected]> wrote in message
news:[email protected]...
> Nick,
>
> I'm not a pro, though i did VBA on and off for some years.
>
> Whats the PrintDialog API ?
>
> If i'm to build a userform, how do i get the list of printers,
> printerstatus, location and so on ?
>
> Claus
>
> "NickHK" <[email protected]> skrev i en meddelelse
> news:[email protected]...
> > Claus,
> > Using the PrintDialog API and hook/templates you can achieve it, but not
> > natively in VBA, AFAIK.
> >
> > Easier would be to make your own userform with the options, then make
> > those
> > changes to the WB and print it yourself.
> >
> > NickHK
> >
> > "Claus" <[email protected]> wrote in message
> > news:[email protected]...
> >> Is there a way to add checkboxes, dropdown ect. to the printdialog,
like
> >> when i'm adding objects to a userform using code ?
> >>
> >> I need to precent some reporttype-choises to the user when the print
> > button
> >> is pressed.
> >>
> >> Hoping for a positive answer
> >>
> >>
> >> Claus
> >>
> >>
> >
> >
>
>

Thank you Nick

I'll dig into it

Claus
"NickHK" <[email protected]> skrev i en meddelelse
news:[email protected]...
> Claus,
> Found this:
> http://pubs.logicalexpressions.com/P...cle.asp?ID=183
>
> NickHK
>
> "Claus" <[email protected]> wrote in message
> news:[email protected]...
>> Nick,
>>
>> I'm not a pro, though i did VBA on and off for some years.
>>
>> Whats the PrintDialog API ?
>>
>> If i'm to build a userform, how do i get the list of printers,
>> printerstatus, location and so on ?
>>
>> Claus
>>
>> "NickHK" <[email protected]> skrev i en meddelelse
>> news:[email protected]...
>> > Claus,
>> > Using the PrintDialog API and hook/templates you can achieve it, but
>> > not
>> > natively in VBA, AFAIK.
>> >
>> > Easier would be to make your own userform with the options, then make
>> > those
>> > changes to the WB and print it yourself.
>> >
>> > NickHK
>> >
>> > "Claus" <[email protected]> wrote in message
>> > news:[email protected]...
>> >> Is there a way to add checkboxes, dropdown ect. to the printdialog,
> like
>> >> when i'm adding objects to a userform using code ?
>> >>
>> >> I need to precent some reporttype-choises to the user when the print
>> > button
>> >> is pressed.
>> >>
>> >> Hoping for a positive answer
>> >>
>> >>
>> >> Claus
>> >>
>> >>
>> >
>> >
>>
>>
>
>