Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How prompt Excel user to fill cell with text, i.e., proposal name
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.) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How prompt Excel user to fill cell with text, i.e., proposal name
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How prompt Excel user to fill cell with text, i.e., proposal n
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How prompt Excel user to fill cell with text, i.e., proposal name
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How prompt Excel user to fill cell with text, i.e., proposal n
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How prompt Excel user to fill cell with text, i.e., proposal name
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 -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=548587 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Capacity - text | Excel Discussion (Misc queries) | |||
Text, Number and Date formats excel 2003 driving experienced user | Excel Discussion (Misc queries) | |||
Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
In MS Excel, how do I fill in a column with the same cell from se. | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |