How prompt Excel user to fill cell with text, i.e., proposal name

[Guest]

Building a budget template for salespeople and want to prompt the user to
enter the name of the customer in one cell and then the name of the proposal
in the other cell. How do I set this up so that a message pops up and
requires them to enter the information? (I've tried data validation, but it
only works if you select the cell. I would like Excel to automatically
prompt them to fill it in.)

 

[Bearacade]

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

 

[Guest]

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]

close your spreadsheet and open it =)

If you need to change the way it works, tell me, I will change th
code for yo

 

[Guest]

Didn't work.

 

[Bearacade]

Can't attached the xls. if you want me to send you a sample file, give
me your email address or send one to me at (e-mail address removed)