The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!
When a UserForm is modal, the user must supply information or close the UserForm before using any other part of the application. No subsequent code is executed until the UserForm is hidden or unloaded. Although other forms in the application are disabled when a UserForm is displayed, other applications are not.
When the UserForm is modeless, the user can view other forms or windows without closing the UserForm.
Modeless forms do not appear in the task bar and are not in the window tab order.
frmMyForm.Show (False)
Is it possible to make floating worksheet means worksheet comes out like popupOk - I think you are going to hit an end to the possibilities of using a pop-up, from Martins comment of using a 2nd workbook I have the idea of using a different program, for example MS Word. The thing is that MS-Office provides something to acheive a pop-up effect and for whatever reason you need something different, but I think we are coming close to exhausting the possibilities.
I need sum of value from one column of Table to the parent worksheet1.Then I am not sure why you need a pop-up at all...
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
You will have to rename the file so that it has the extension ".xlsm"
Sheet 2 is hidden. Pressing the button unhides and displays it.
Pressing OK or cancel on sheet 2 will rehide.
workSheet-PopUP--DT.zip