What type of dialog box?
Interactive or static?
Simple one could be like
Private Sub Workbook_Open()
whatname = InputBox("enter your name here")
MsgBox "Hello there " & whatname & ". What can I do for you today?"
End Sub
Placed in Thisworkbook module.
Gord Dibben MS Excel MVP
>Hi,
>I am wanting to create and design a dialog box to open up in my workbook in
>excel but cannot remember how to start. I would be very grateful for help on
>this matter.
>
>Cheers