[發問] 表單問題

shadowming

各位先進
請問要怎麼讓vba表單大小跟使用者螢幕大小一樣?
還有我想要讓excel打開時，只看到表單，讓workbook隱藏起來
這樣要怎麼設定呢?
麻煩知道的人幫我解答一下

yanto913

Call myForm1
應該是改成
   myForm1.Show

yangjie

隱藏workbook之方法:
於VBAproject之Excel物件(Thisbook)內語法
Private Sub Workbook_Open()
    Application.Visible = False
    Call myForm1
End Sub
由Form1做螢幕畫面

shadowming

謝謝兩位版主的指導
更謝謝Hsieh版主對我最近發表的問題都幫我解答
非常感恩!!

Hsieh

以Application的大小位置為依據

1. Private Sub UserForm_Initialize()
   
2. With Application
   
3. Me.Top = .Top
   
4. Me.Left = .Left
   
5. Me.Height = .Height
   
6. Me.Width = .Width
   
7. End With
   
8. End Sub

複製代碼

kimbal

把UserForm1換一下你的form名

1. Private Sub UserForm_Initialize()
   
2.     Application.WindowState = xlMaximized
   
3.     appWidth = Application.Width
   
4.     appHeight = Application.Height
   
5.     UserForm1.Top = 1
   
6.     UserForm1.Left = 1
   
7.     UserForm1.Width = Application.Width
   
8.     UserForm1.Height = Application.Height
   
9.     Application.Visible = False
   
10. End Sub
    
11. 
    
12. Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
    
13.     Application.Visible = True
    
14. End Sub

複製代碼