Form to Launch Before Spreadsheet

[Fallenwing]

Hey, I want to make a form using VBA that pops up immediately when you open a spreadsheet(in fact I want the spreadsheet itself to be hidden, I just need it for the data that will be displayed on the forms.) In essence this would work fine with just Visual Basic, but I know VBA much better and i don't think data referencing to Excel works with VB like it does with VBA. Is this possible or am I just dreaming?

 

[Loomah]

Hi
I'm not sure this is exactly the sort of thing you're looking for but it may be a good starting point. However the workbook is visible for a short while before it disappears.

Private Sub Workbook_Open()
ActiveWindow.Visible = False
UserForm1.Show
End Sub

;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244

 

[Fallenwing]

Thanks Loomah. Does anybody else out there know of a way to activate a form without any trace of the workbook popping up? I'd love to know. This could also be a powerful tool in making a free VB alternative built into every computer with Office.

 

[luceze]

I believe you can just go to window/hide then save the workbook. Then modify Loomah's code like this:
Private Sub Workbook_Open()
UserForm1.Show
End Sub

HTH,
Eric