Display Date In an Input Box

[Computer8822]

Hello,

I have a casl macro program that will ask for several options through popup input boxes. One of them asks for the date. I was wondering if there was a way to diplay the date within this popup box so the user will pretty much just have to hit enter? The date will display as mmddyyyy.

 

[blckngldhwk]

If you're using Attachmate's Macro Editor then it should be fairly simple.

Begin Dialog newdlg 125, 5, 185, 90
        
OkButton  130, 5, 50, 15
CancelButton  130, 25, 50, 15
        
Text  20, 15, 70, 15, date
        
End Dialog

This is just a simple dialog box that displays the date but the important part of the code is text line. Hope that helps.

 

[streetprog]

You can also use the InputBox function as shown below

Dim sDate as string
sDate = InputBox("Enter the date you want:", "Any Caption", Format(Date, "mmddyyyy"))