RE: How to invoke a user form from a custom button on the menu bar

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks very much J. It works. Great. Red-faced. I shoulda thought of
that as my first attempt. I do attempt to do due diligence before crying
for help.
As the user form of interest is written to be applicable to any form I next
want to make this form and the custom button on the menu bar come up on every
Excel sheet. Maybe that needs to be an OCX when is an "add-in" to Excel?
I thought I recalled there is a place to save macros to be applicable to all
forms, but I haven't found it yet. Thanks again.
--
Lamont Phemister


"JMay" wrote:

Userform1.show

"Lamont" wrote:

I have a user form I would like to execute from a custom button on the
worksheet menu bar. I don't want a user to have to click Tools|Macro|Visual
Basic Editor and then have to scroll to the start procedure in the form to
invoke the form. It seems like I ought to simple add a button to the menu
bar and let the user click the button to bring up the form?

I have tried to reference the user form from a custom button added to the
menu bar, and from a button inserted on the form.

I have tried all the ways to refer to the user form that I can think of
but all return errors.

Please, can someone tell me to invoke this user form, or any VBA procedure,
for that matter.

Thank you for kind assistance.

Lamont

P.S.
I would like to make this the user button to invoke this particular user
form appear automatically on all worksheets.

It builds a list of column headings in a list box upon invocation.
The user can then select up to 6 sort fields which are added to
an MSFlexGrid control with "Ascend" set as default order for each item.
The user can toggle the ascend/descend for teach item in the Flex Grid.

The user can click a "Clear Sort" to clear the grid and permit
re-selection of sort items.

The user then should click the "Run Sort" button on the form to
excecute the sort.
--
Lamont
.

Relevant Pages

  • Re: News readers , GOOGLE Sucks
    ... Then, click the message that got you into that thread, and click the sort by date bar. ... I find Thunderbird much easier than GG, because GG only shows 10 messages at a time when in tree mode. ... I like google groups most of the time. ...
    (rec.games.pinball)
  • AMC Yawner... when you cant come up w/ new ideas, recycle, recycle!
    ... you mean this silly bar idea will go beyond off-camera antics? ... Besides the sort of icky mix message they're sending to _part_ of their ... core audience, ... Electronics is anything more than an old 'The Time Machine' ('60s ...
    (rec.arts.tv.soaps.abc)
  • Re: Something new to me
    ... The sort of action story Bill ... Well, I did say a yellow flag, not a red one -- meaning not that you ... his buddies start comparing notes with other teams... ... bar, you should look a little harder for a solution and maybe combine it ...
    (rec.arts.sf.composition)
  • Re: Niggling away at the edges (related to Homemade bullet proof vest)
    ... at Baen's bar rather than here is that any deviation ... That is our sort of stuff, but it's focussed on a single ... I suspect he would have more problems in an online community made up of ... mirror 1: http://dsgood.insanejournal.com ...
    (rec.arts.sf.composition)
  • Re: OT: Sanity prevails in Holland
    ... I am tempted to invoke Godwin's Law. ... And it seems to me the sort of people who murdered Theo van Gogh and made death threats that caused Ayaan Ali Hirsi to flee the country have more in common with Herr Schickelgruber than does Mr. Wilders. ...
    (rec.music.classical.recordings)