View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ajliaks ajliaks is offline
external usenet poster
 
Posts: 1
Default Excel VBA question - showing userform when opening workbook

Hi,

I created a userform called "Choose".
I need to show this userform when I open the workbook.

How is the code to do that?
I tried writting in "This Workbook" something like:

Dim Choose As UserForm
Private Sub Workbook_Open()
Application.Choose_Open
End Sub


I also need to called another userform called "Import" when clickin
cmdProceed in Choose UserForm, I've tried this:

Private Sub cmdProceed_Click()
If OptionImport.Value = True Then
UserForm.Initialize (Importing)
Else
If OptionExport.Value = True Then
UserForm.Open (Exporting)
End If
End If
'Unload me
End Sub

Thanks

--
Message posted from http://www.ExcelForum.com