microsoft.public.word.vba.general

fumei & Jay,
Thank you for your assistance. It's feels good to not be alone in this
Microsoft Jungle!!!
--
James III,
Sincere VBA Newbie!


"Jay Freedman" wrote:

> I agree with all of fumei's points. I'll just take on the one section that
> wasn't addressed yet:
>
> >> then to hide the userform. However, the code I used is in the
> >> ...button_click() subroutine. Since I will have numerous steps, it
> >> will require a _click() subroutine for each step. Is there anyway
> >> to trigger on a mouse click without the associated code being tied
> >> to a specific control?
>
> I'm not quite clear on what constitutes a step, but in general you have to
> provide an event procedure for every event you want to respond to. That may
> be a button click, a character typed or erased in a text box (the "change"
> event of that control), entry into or exit from a control, etc. So the
> answer to your question is "no".
>
> If you provide helper functions in the userform code, then a lot of these
> event procedures will consist of only one or two lines of code that call a
> helper function with the proper arguments and then set a value or branch on
> the result of the function. An example of a helper function might be one
> that takes a value and determines whether it's valid for the current
> control, returning a Boolean value (similar to the built-in IsNumeric
> function). In addition to the value itself, you can pass limits and other
> criteria as arguments.
>
> A lot of these little event procedures can be "written" by copy/paste/small
> edit. Also, you can use the two dropdowns at the top of the VBA editor
> window for speed: select the control from the left dropdown, select the
> event from the right dropdown, and VBA will create the event procedure's
> first and last lines for you.
>
> You should also look into the Multipage control, which lets you create more
> than one page in a userform and use Back and Next buttons to control
> navigation.
>
> --
> Regards,
> Jay Freedman
> Microsoft Word MVP FAQ: http://word.mvps.org
> Email cannot be acknowledged; please post all follow-ups to the newsgroup so
> all may benefit.
>
> fumei via OfficeKB.com wrote:
>
> >> [quoted text clipped - lots of lines]
> >>>>
> >>>> Any suggestions would be greatly appreciated!
>
>
>