R Ron Simon Joined Aug 1, 2010 Messages 2 Reaction score 0 Aug 1, 2010 #1 I opened a form in Excel (2007), that insert data to the worksheet. When I close the form by one of the commands: "unload" or "close" or manualy the data disappear. What is the solution?
I opened a form in Excel (2007), that insert data to the worksheet. When I close the form by one of the commands: "unload" or "close" or manualy the data disappear. What is the solution?
EvanDavis Silly Fool Joined Jun 20, 2010 Messages 5,308 Reaction score 689 Aug 1, 2010 #2 Can you post the VBS for the unload function ?
R Ron Simon Joined Aug 1, 2010 Messages 2 Reaction score 0 Aug 1, 2010 #3 Private Sub cmd_Table_Click() ... Unload UserForm1 End Sub 'cmd_Table_Click()
