Is it possible to write a wizard in VBA

I'd like to use VBA to write a wizard that handles a series of conditionals.
If this then display that; with next and previous capability. Is this
possible in VBA please?
TIA

Philip

Jezebel
Sat Mar 17 17:40:03 CDT 2007

Yes.


"PPL" <pp2@shaw.ca> wrote in message news:yDYKh.31295$DN.6493@pd7urf2no...
> I'd like to use VBA to write a wizard that handles a series of
> conditionals.
> If this then display that; with next and previous capability. Is this
> possible in VBA please?
> TIA
>
> Philip
>
>

Jonathan
Sun Mar 18 04:11:40 CDT 2007


"Jezebel" <warcrimes@whitehouse.gov> wrote in message
news:ulab1UOaHHA.3272@TK2MSFTNGP05.phx.gbl...
> Yes.
>
>

Jezebel,

It would be nice if your answers could be helpful as well as merely correct.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

Jonathan
Sun Mar 18 04:11:10 CDT 2007


"PPL" <pp2@shaw.ca> wrote in message news:yDYKh.31295$DN.6493@pd7urf2no...
> I'd like to use VBA to write a wizard that handles a series of
> conditionals.
> If this then display that; with next and previous capability. Is this
> possible in VBA please?
> TIA
>
> Philip
>
>

Hi Philip,

Yes, this is possible.

The user interface would be a UserForm. Take a look at this article for how
to create one of those

How to create a Userform
http://www.word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

On the UserForm, you will probably want a MultiPage control to handle
displaying groups of items. If you have done a complete install of Office,
you will probably be able to find the Batch Conversion Wizard as one of the
templates installed. Take a look at the code in that.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

PPL
Sun Mar 18 09:08:16 CDT 2007

Thanks for your informative reply Jonathan. From the details you've given
me, I now have somewhere to start looking!
I've used UserForms before, but I am hoping not to have to re-invent the
wheel.
I guess I'm looking for the capability of using Forward and Back buttons
without having to write reams of code allowing the history of user actions
to be retrieved.

I'll take a lok at the refererences that you've suggested and see if I come
up with anything. The Batch Conversion Wizard sounds interesting I'll see if
I can get some ideas from that.

Thanks again Jonathan.

Philip


"Jonathan West" <jwest@mvps.org> wrote in message
news:%23$T%2333TaHHA.588@TK2MSFTNGP06.phx.gbl...
>
> "PPL" <pp2@shaw.ca> wrote in message news:yDYKh.31295$DN.6493@pd7urf2no...
>> I'd like to use VBA to write a wizard that handles a series of
>> conditionals.
>> If this then display that; with next and previous capability. Is this
>> possible in VBA please?
>> TIA
>>
>> Philip
>>
>>
>
> Hi Philip,
>
> Yes, this is possible.
>
> The user interface would be a UserForm. Take a look at this article for
> how to create one of those
>
> How to create a Userform
> http://www.word.mvps.org/FAQs/Userforms/CreateAUserForm.htm
>
> On the UserForm, you will probably want a MultiPage control to handle
> displaying groups of items. If you have done a complete install of Office,
> you will probably be able to find the Batch Conversion Wizard as one of
> the templates installed. Take a look at the code in that.
>
>
> --
> Regards
> Jonathan West - Word MVP
> www.intelligentdocuments.co.uk
> Please reply to the newsgroup
>
>

Jonathan
Mon Mar 19 06:39:04 CDT 2007




"PPL" <pp2@shaw.ca> wrote in message news:kJbLh.34570$zU1.12911@pd7urf1no...
> Thanks for your informative reply Jonathan. From the details you've given
> me, I now have somewhere to start looking!
> I've used UserForms before, but I am hoping not to have to re-invent the
> wheel.
> I guess I'm looking for the capability of using Forward and Back buttons
> without having to write reams of code allowing the history of user actions
> to be retrieved.
>

Forward & Back buttons are fairly straightforward. The Value property of the
Multipage control determines which page is currently displayed.

Therefore, all the Forward and Back buttons need do (in their Click event)
is respectively increment or decrement the Value property of the MultiPage,
with appropriate error checking to see if you are on the first or last page.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

PPL
Sun Mar 25 08:49:22 CDT 2007

Thanks for your help Jonathon, I'll try it.
Philip


"Jonathan West" <jwest@mvps.org> wrote in message
news:%23PCg2shaHHA.4716@TK2MSFTNGP02.phx.gbl...
>
>
>
> "PPL" <pp2@shaw.ca> wrote in message
> news:kJbLh.34570$zU1.12911@pd7urf1no...
>> Thanks for your informative reply Jonathan. From the details you've given
>> me, I now have somewhere to start looking!
>> I've used UserForms before, but I am hoping not to have to re-invent the
>> wheel.
>> I guess I'm looking for the capability of using Forward and Back buttons
>> without having to write reams of code allowing the history of user
>> actions to be retrieved.
>>
>
> Forward & Back buttons are fairly straightforward. The Value property of
> the Multipage control determines which page is currently displayed.
>
> Therefore, all the Forward and Back buttons need do (in their Click event)
> is respectively increment or decrement the Value property of the
> MultiPage, with appropriate error checking to see if you are on the first
> or last page.
>
>
> --
> Regards
> Jonathan West - Word MVP
> www.intelligentdocuments.co.uk
> Please reply to the newsgroup
> Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org