Setting a default value?

  • Thread starter Thread starter Grace
  • Start date Start date
G

Grace

Is there a way to set a default value in a cell? I have a
column that looks at a list of values which are stored on
a separate sheet. I would like the value to default to a
value on that list.

Thanks for your help,
Grace
 
how about somehting like a sheet activate event where if target.address then
target=sheets("sheet1").range("a2")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table - value field settings - default? 2
Help with setting a "not found" statement 3
need a VB code 4
Default value for an excel formula 4
VBA: How can I use a string variable as autofilter criteria? 4
Possible Indirect query 1
Default In-Cell Dropdown to a specific Index Value? 1
Default value in CF Excel 2007 3

Back
Top