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
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
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.