Shortcut/Button to start VBA userform


R

rossbielski

I am trying to find a way open a userform inside my visio diagram through
pushing shortcut keys, or by clicking on a button on the document. I have the
userform startup when the document is opened and close it when I am done with
using it, but I want to be able to bring it back when I need it again without
running it through vba editor.
 
Ad

Advertisements

S

SteveM

I am trying to find a way open a userform inside my visio diagram through
pushing shortcut keys, or by clicking on a button on the document. I havethe
userform startup when the document is opened and close it when I am done with
using it, but I want to be able to bring it back when I need it again without
running it through vba editor.

"without running it through the vba editor" is not clear to me.

You can add a Microsoft Forms CommandButton from the Developer Tool
Bar and then Open your form using the CommandButton Click event.

Simple enough?

SteveM
 
J

JuneTheSecond

1. "through pushing shortcut keys"
You can make a macro that start with short cut key
by recording your operation with such option..

2. "but I want to be able to bring it back when I need it"
VBA UserForm cannot go behind Visio,
but if you open UserForm with VBModeless mode,
you can access Visio drawing while UserForm is visible.
--
Best Regards.

JuneTheSecond
Now, visual calculation is more visual.
http://www.geocities.jp/visualcalculation/english/index.html
 
R

rossbielski

Looks like that one is a no-go. I got an error that stated too many shapes.
Its a pretty large diagram and looks like it wont let me add a command-button
for whatever reason. Thanks though. It does work great on smaller diagrams,
just not mine. I got shortcut keys too work, which is better I think anyways
than trying to find a button on a page.
 
Ad

Advertisements

R

rossbielski

Thats it. The shortcut key works perfect. I was getting frustrated by not
being able to move the diagram while I was working, so thanks for the forward
thinking and advice. You helped out my workcenter in ways you can't imagine
with that tip.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top