Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-26-2011, 07:54 AM
flackend flackend is offline Automatically select first item in drop-down? Windows XP Automatically select first item in drop-down? Office 2003
Novice
Automatically select first item in drop-down?
 
Join Date: Aug 2011
Posts: 6
flackend is on a distinguished road
Question Automatically select first item in drop-down?

Is there a way to have the first item in a data validation drop-down list automatically selected?



I have a workbook set up with dependent lists data validation. So I enter the first cells data, 5:30 PM. The second cell's data validation is always the first cell's time + two hours. Instead of clicking the drop-down list and selecting the only option, 7:30 PM, is there a way to have the value selected automatically?

Thanks!
Reply With Quote
  #2  
Old 08-27-2011, 03:28 AM
Catalin.B Catalin.B is offline Automatically select first item in drop-down? Windows Vista Automatically select first item in drop-down? Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

select the default value in the first cell in the column , then copy down the cell, as in sample attached
Attached Files
File Type: xls Book1.xls (20.5 KB, 100 views)
Reply With Quote
  #3  
Old 08-28-2011, 05:48 AM
nutrastat nutrastat is offline Automatically select first item in drop-down? Windows 7 64bit Automatically select first item in drop-down? Office 2010 32bit
Advanced Beginner
 
Join Date: Aug 2011
Location: Brighton, UK
Posts: 36
nutrastat is on a distinguished road
Default Why Two Validation Lists?

Hi,

Note sure why you have two validation lists, when the second is always 2 hours different.

See attached example, I have created a short time validation list to the right. Select time in Col A, and Col C will show new time, plus 2 hours.

Hope this helps.
Attached Files
File Type: xlsx Time Example Doc.xlsx (10.6 KB, 47 views)
Reply With Quote
  #4  
Old 08-29-2011, 01:33 PM
flackend flackend is offline Automatically select first item in drop-down? Windows XP Automatically select first item in drop-down? Office 2003
Novice
Automatically select first item in drop-down?
 
Join Date: Aug 2011
Posts: 6
flackend is on a distinguished road
Default

I'm using data validation instead of a formula directly in the cell because I want the user to be able to enter a time other than 2 hours later without having to erase the formula.

I attached my spreadsheet. I'm just wondering if there's a way to have whatever the first item in the data validation drop-down list be selected automatically.
Attached Files
File Type: xls Classes Data.xls (34.0 KB, 38 views)
Reply With Quote
  #5  
Old 08-29-2011, 02:07 PM
nutrastat nutrastat is offline Automatically select first item in drop-down? Windows 7 64bit Automatically select first item in drop-down? Office 2010 32bit
Advanced Beginner
 
Join Date: Aug 2011
Location: Brighton, UK
Posts: 36
nutrastat is on a distinguished road
Default

Hi,

You need VBA, cannot help you here. The closest I have seen to your requirement is...

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

It is a dependant list. But you would still need to select second list, and this is based on the first list.

Sorry I cannot help more on this occasion.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Item Already updated simon@resultsoftware.co.u Outlook 0 07-25-2011 04:30 AM
Automatically select first item in drop-down? Recovering Deleted Item from BCM alwbass Outlook 1 06-23-2011 12:59 PM
25 item max in drop down form sonicvalley Word 0 07-26-2010 11:12 PM
How would I bulk select and copy highlights and then bulk paste them automatically? copywriterpro Word 0 04-19-2010 05:21 AM
Referens to an item list... matbli Word 0 10-29-2009 08:04 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft