Geek asks and answers

How to add a custom form as an icon / button to the ribbon and show a custom form, but can you still work with the Excel file?

When I am a user user form, I have to:

1) Alt + F11

2) Choose a form

3) Run

4) Close the form

5) Return to Excel

Excel won't let me do anything unless the form is closed. Is there anything to put a small icon on the ribbon? And save the user form while I work with Excel?

+3
source share
3 answers

You have two parts to your question:

Adding an icon to the feed . Do you want the macro to be available for all spreadsheets?

  • , , Excel, .
  • , , , ( ), ( , Assigning a shortcut to an existing macro)

:. UserForm ShowModal; false. , MyForm.Show vbModeless.

, , : StartUpPosition 0 - Manual Top Left.

+3

:) modeless, Excel

.

Sub Sample()
    Userform1.Show vbModeless
End Sub
+2

I think you will need to create another module and call the user form in this module. After that, just place this macro on the tape. It can help you.

0
source

More articles:


All Articles