Message Box

[Db1712]

Is there a way to have a message box or drop down box open when acessin
a work sheet within a excel spread sheet that prompts for informatio
thats linked to another sheet and cell. For instance the box woul
prompt the user to input Sales and Estimate Sales both imputs would g
to a different sheet and different cells. Thanks for any assistance i
advanc

 

[Don Guillett]

right click the sheet tab>view code>left window second option>right
window>activate.

 

[Debra Dalgleish]

You can use Data Validation to create dropdown lists. There are
instructions in Excel's Help, and here:

http://www.contextures.com/xlDataVal01.html

For example, you could have data validation list on Sheet1, in cells C2
and D2. In the cells above, you could type headings, so users know what
to enter in the cells.