Hey Guys,


I've created a program to load and manipulate text files of data. When the macro is initiated the first thing the user encoutners is my userform which contains 5 textboxes requiring the user to input integer values in the text box. The only buttons on the userform are a calculate button and a cancel button. I have already written the code for the cancel button but need some assistance witht the calculate button. Currently, pressing the calculate button hides the userform and loads a file launcher where the user can select their data file and then the macro imports the data directly into an excel worksheet. Once this is completed the userform unloads. However, at the moment the calculate button will launch the file chooser even if the 5 textboxes are empty. This is my first issue:

What is a simple and efficient code to prevent the file chooser from launching if the textboxes are not all filled with integer values?

Secondly,
How can I display these textbox values in my newly generated spreadsheet?

Here is my code for the calculate button so far:


Private Sub Done_Click()

Dim blnFileOpened As Boolean

Initialize.Hide

blnFileOpened = OpenText

If blnFileOpened Then
    Call Destrezas
End If

Unload Me

End Sub
Thanks again!