LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default using pulldown list with a list and autocompleet function

how can i make a pulldown list with autocompleet and first letter reconiction.

I have the list working with data validation
but now the rest.

The list is on sheet 2

I am now using the data Validation with list as allow
The source formula is "=Workcode" (area name) and workcode is on sheet 2.
Sheet 1 is used to display the list.

thanks

 
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
External excel file for pulldown list source Alan Lindner Excel Worksheet Functions 2 April 15th 09 06:48 AM
How to set excel pulldown list starting value to current cell valu Nolo44 Excel Discussion (Misc queries) 1 January 28th 07 06:59 PM
Help with hyperlinks in pulldown list. Anyone know how? Wayne Knazek Excel Discussion (Misc queries) 0 June 26th 06 04:29 PM
Help with hyperlinks in pulldown list. Anyone know how? Wayne Knazek Excel Worksheet Functions 0 June 26th 06 04:26 PM
Still need help with hyperlinks in pulldown list. Anyone know how Wayne Knazek Excel Discussion (Misc queries) 0 June 26th 06 03:40 PM


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

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

About Us

"It's about Microsoft Excel"