Thread: Dialogue Box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ed ed is offline
external usenet poster
 
Posts: 59
Default Dialogue Box

Hi

I have the following code for a dialogue box. How do I
dislpay some text in the box?

I ahve tried the text property but it is not displaying
any text.

With PrintDlg.DialogFrame
..Height = Application.Max(68, PrintDlg.DialogFrame.Top +
TopPos - 34)
..Width = 230
..Text = "Please Select Only One Sheet and Click Select:"
..Caption = "Select Sheet to Import"
End With