PDA

View Full Version : [SOLVED:] Forms always visible



Macpress
10-23-2013, 07:46 AM
good day I created a form I would like to know the command to keep it always visible, let the spreadsheet attached thanks

SamT
10-23-2013, 08:03 AM
I am moving this thread to the Excel Forum.

Please take the time to read the Forum FAQ link in my signature.

Thank you.

Macpress
10-23-2013, 08:37 AM
sorry for posting in the wrong place, I'm trying to make is that the form I created, it closes the form and have no option to open again, I would have to create another button? I do not know if I'm asking this field correctly or if I should go to another place from what I understand I have been moved from where I was ereei anticipate my apologies again, grateful

SamT
10-23-2013, 12:40 PM
In VBA, Use the View Menu to show the Properties window. Click on the UserForm background and set the ShowModal property to "False."

Paul_Hossler
10-23-2013, 07:20 PM
another way



Option Explicit

Private Sub Workbook_Open()
Call UserForm1.Show(vbModeless)
End Sub




Paul

Macpress
10-24-2013, 05:39 AM
Paul thank you very much, that was really needed

Macpress
10-24-2013, 05:41 AM
Thanks for the feedback, helped me to improve my knowledge