![]() ![]() I use WindowXP and MS Office 2010, but I saved this workbook as Excel 97-2003 Workbook (*. If I do so, When I minimize and then re-activate the Excel Application Window, I can only see the origial UserForm1 in the screen and other instanaces have gone. actually, without using at least 3000 of Sleep, my following script never works. When I re-activate the Excel Application Window after minimized it, I still can see all opened instances in the screen.īut I cannot add any CommandButton in the UserForm1. If I click the UserForm1, another instance opens and magbox tells how many instances are open. The Developer tab is the toolbar that has the buttons to open the VBA editor and create Form/ActiveX Controls like buttons, checkboxes, etc. First, be sure that the Developer tab is visible in the toolbar in Excel. I also add the following code in thisworkbook open event sub: UserForm1.showĪfter open this workbook, UserForm1 shows. You can access the VBA environment in Excel 2010 by opening the Microsoft Visual Basic for Applications window. ![]() Msgbox( & " instances of UserForm1 are open") Windows 2008 Server 圆4 Please make this folder. A possibility can be Sharepoint which has features for that. ![]() I wrote the following code in UserForm1 click event sub dim newuserform as new Userform1 Be aware that you cannot reach Excel in a webpage on a client. I created a userform called UserFrom1 and set its ShowModal as false. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |