Hi everyone,
Sorry for my poor English in advance.
I tried to write some VBA sub and want to find easy way to open the VBA userform.
How can I do it?
I hope I can call it from command bar, or set toolbar ribbon(I'm not sure its the right name, anyway the label on the top)
to call the userform.

Thanks!

Hi,
You can create a new button and add it to a toolbar or menu.
The macro for the new button: Please refer to the attached image.

QuanNguyen wrote: ↑

Tue Oct 15, 2024 6:28 pm

Hi,
You can create a new button and add it to a toolbar or menu.
The macro for the new button:

Code: Select all

C^C^P-vbarun "C:\IntelliCad\VBA_example.vbi!Module1.UserFormEx"

Please refer to the attached image.
CallUserForm.png

Thaks alot!!
I found the way later, by using Lisp
like this
---
(defun c:MMNu() ;MMNu is function name
(vl-load-com)
(setvar "cmdecho" 0)
(command "-vbarun" )
(command "MainMnu_UFS" ) ;MainMnu_UFS is VBA macro name
(setvar "cmdecho" 1)
)
----
I will try your method too
really appreciate