Is it possible to write a wizard in VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PPL - 17 Mar 2007 21:58 GMT

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

Reply to this Message

Jezebel - 17 Mar 2007 23:40 GMT

Yes.

> I'd like to use VBA to write a wizard that handles a series of
> conditionals.
[quoted text clipped - 3 lines]
>
> Philip

Reply to this Message

Jonathan West - 18 Mar 2007 10:11 GMT

> Yes.

Jezebel,

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

Signature

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

Reply to this Message

Jonathan West - 18 Mar 2007 10:11 GMT

> I'd like to use VBA to write a wizard that handles a series of
> conditionals.
[quoted text clipped - 3 lines]
>
> 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.

Signature

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

Reply to this Message

PPL - 18 Mar 2007 15:08 GMT

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

>> I'd like to use VBA to write a wizard that handles a series of
>> conditionals.
[quoted text clipped - 18 lines]
> 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.

Reply to this Message

Jonathan West - 19 Mar 2007 12:39 GMT

> Thanks for your informative reply Jonathan. From the details you've given
> me, I now have somewhere to start looking!
[quoted text clipped - 3 lines]
> 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.

Signature

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

Reply to this Message

PPL - 25 Mar 2007 14:49 GMT

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

>> Thanks for your informative reply Jonathan. From the details you've given
>> me, I now have somewhere to start looking!
[quoted text clipped - 11 lines]
> MultiPage, with appropriate error checking to see if you are on the first
> or last page.

Reply to this Message