Well, I've stumbled my way through finding the ThisWorkbook and pasting your
formula there. But now how do I get it to work? (Novice)

"Bearacade" wrote:


Put this in your ThisWorkbook inside VBA
Change A1 and B1 to the cells you want to propulate

Private Sub Workbook_Open()

Dim CustName As String
Dim PropName As String

CustName = InputBox("What is Customer's Name?", "Customer's Name")
PropName = InputBox("What is the name of the Proposal?", "Proposal
Name")

Range("A1").Value = CustName
Range("B1").Value = PropName

End Sub


--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=548587