Bruce,

Yep! Here's using a named cell, and using a cell reference...

''''''''''''''''
Dim mssg As String

mssg = InputBox("do your thing", "my thing",
Sheets("Sheet3").Range("Function"))
mssg = InputBox("do your thing", "my thing", Sheets("Sheet3").Range("B5"))
'''''''''''''''''''''
hth
--

steveB

(Remove 'NOSPAM' from email address if contacting me direct)


"BruceAtkinson " wrote in
message ...
Can the DEFAULT parameter in an InputBox, reference a cell? I would
like to use the value in another cell as the InputBox Default value.
Can this be done? If so, how; especially on another worksheet?
Thanks,
Bruce


---
Message posted from http://www.ExcelForum.com/