Is it possible to write a wizard in VBA

[PPL]

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]

Yes.

 

[Jonathan West]

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.

 

[Jonathan West]

Yes.

Jezebel,

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

 

[PPL]

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]

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]

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