Is it possible to open another file when there is a Userform on the screen?
I'm aware you can open a UF as vbModeless but I have the following code to unload and clear a file down when a UF is closed
As soon as the form shows, it disappears as the remainder of the modules code executes.
TIA
I'm aware you can open a UF as vbModeless but I have the following code to unload and clear a file down when a UF is closed
VBA Code:
With frmProperty
.Show vbModeless
End With
Unload frmProperty
Range("Holding_Room") = ""
Range("Holding_System") = ""
Range("Holding_SystemCI") = ""
As soon as the form shows, it disappears as the remainder of the modules code executes.
TIA