View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Juan Pablo González Juan Pablo González is offline
external usenet poster
 
Posts: 226
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:


Try with

Private Sub Workbook_Open()
Choose.Show
End Sub



I also need to called another userform called "Import" when clicking
cmdProceed in Choose UserForm
Thanks.


Try

Private Sub cmdProceed_Click()
Import.Show
End Sub

if you just need to initialize it, as your code suggests, try with

Load Import

--
Regards,

Juan Pablo González