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

D

Deb

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.)
 
B

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
 
D

Deb

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)
 
B

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
 
Top