Using VBA code to create a command bar entry to open a form

J

Jonathan Blitz

I have VBA to that creates a command bar and the buttons on the bar.

I have no problem getting it to run a macro or a function (using the
onaction property).
However, I cannot get it to open a form.
What parameters do I need to set when I create the button so that it can
open a form directly.

I compared it to one that I created "by hand" and I can't see any difference
so it must be some hidden value somewhere.

I suppose I could run a macro to do it but that would be very ugly.

Any ideas?

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 

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

Similar Threads

Creating a Search using a combo box and then creating a report. 4
How can I get a Shareable URL via VBA code to a OneDrive image? 0
I can create Publisher documents, but I can not open / read them. 0
Changing drop-down menu at run time 0
Using VBA code to create a command bar entry to open a form 1
Get list of files in directory 3
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0

Top