Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 5th 06, 03:35 PM posted to microsoft.public.excel.misc
Deb
 
Posts: n/a
Default 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   Report Post  
Old June 5th 06, 04:36 PM posted to microsoft.public.excel.misc
Bearacade
 
Posts: n/a
Default 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   Report Post  
Old June 5th 06, 05:13 PM posted to microsoft.public.excel.misc
Deb
 
Posts: n/a
Default 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   Report Post  
Old June 5th 06, 06:25 PM posted to microsoft.public.excel.misc
Bearacade
 
Posts: n/a
Default 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   Report Post  
Old June 5th 06, 10:41 PM posted to microsoft.public.excel.misc
Deb
 
Posts: n/a
Default 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   Report Post  
Old June 5th 06, 11:41 PM posted to microsoft.public.excel.misc
Bearacade
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell Capacity - text i2meek Excel Discussion (Misc queries) 4 March 13th 06 12:06 AM
Text, Number and Date formats excel 2003 driving experienced user E F Bat Excel Discussion (Misc queries) 1 January 6th 06 07:10 PM
Wrap text limits in Excel 2003 cell formatting Adelrose Excel Discussion (Misc queries) 1 April 19th 05 06:32 PM
In MS Excel, how do I fill in a column with the same cell from se. krempin Excel Worksheet Functions 2 February 9th 05 08:43 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM


All times are GMT +1. The time now is 09:58 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017