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

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

[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

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

"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
>
>

[Bearacade]

close your spreadsheet and open it =)

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

[Deb]

Didn't work.

"Bearacade" wrote:

>
> close your spreadsheet and open it =)
>
> If you need to change the way it works, tell me, I will change the
> code for you
>
>
> --
> Bearacade
>
>
> ------------------------------------------------------------------------
> Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
> View this thread: http://www.excelforum.com/showthread...hreadid=548587
>
>

[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 [email protected]