Look at the VBA help for InputBox.

Regards,
Tom Ogilvy


"Gordon Humphreys" wrote in message
...


Many thanks to Hank Scorpio and Dave for solving the 'screen
glassed-over' problem. I have another, back to converting an Excel4
macros system to VB.

In Excel 4, =INPUT("Use this again or overwrite",3, "Enter accounting
date", Z99) [where Z99 is the cell with the instruction], has the effect
of repeating last time's entry. It works even if the file has been
closed overnight.

What is the VB equivalent? I hoped this would work

Dim BlankName As String
BlankName = InputBox("Enter the name k", _
"Name of the blank sheet you wish to use", BlankName)
Documents.Open BlankName

but it doesn't ie the input box comes up blank. Is there a way of
making the default from the previous entry?



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!