Thread: Help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick[_2_] Bernie Deitrick[_2_] is offline
external usenet poster
 
Posts: 176
Default Help

Peter,

You need a macro to show the userform. It could be called from the auto-open macro or the workbook's open event.

Sub ShowUserform()
Load Userform1
Userform1.Show
End Sub

Change 'Userform1' to the name of your userform.

HTH,
Bernie
Excel MVP


"Peter Baranya" wrote in message ...
Hi
I'd really need some help with Exel. I've written a
Userform using the Visual Basic program of Exel. My
Problem is that I can't seem to display it in my
Workbook. It's a menu that allows the user to select
languages to wiew the sheet with the use of buttons. I'd
like it to come up whenever anyone opens the workbook, or
display this box in one of the sheets. I'd really
appreciate any help.


Thanks a lot
Newt