User Form Menu

[howard]

I have set up a user form nmenu which is linked to various macros

The User form works well, except that after selecting the radio button and clicking ok, I cannot see the data on the screen and have to close the user form

I would like be able to see the data when the user form is open/activated

It would be appreciated if someone could kindly amend my code so that I can see the data whilst the user form is open

 Private Sub CancelButton_Click()
Unload UserForm1
End Sub

Private Sub OKButton_Click()
Application.ScreenUpdating = False

If OptionUpdate Then
Update_Data
   End If
   If OptionClearData Then
Clear_Data
   End If
end Sub

 

[Zot]

What you meant? Userform cover the screen or when userform on top of the sheet, the sheet goes blank?

Do you show userform modal or modeless?

 

[howard]

The sheet does not go blank, but I can only see the data once updated when I close the userform


I have set Modal to false and can now see the screen whilst user form is open

 

[Zot]

The sheet does not go blank, but I can only see the data once updated when I close the userform


I have set Modal to false and can now see the screen whilst user form is open

You can only see data updated after closing the Userform because you have this line

Application.ScreenUpdating = False

The advantage of using it is that your code run faster in most cases. Also prevent screen from flickering if there are values change during execution.

 

[howard]

Thanks for letting me know