Drop Down Lists 2007


"Excel VBA Help"

 


Play Friv Now - Play Friv Games
Go Back   The Code Cage Forums > Microsoft Topics > Microsoft Excel Forum
Our Info Pages:-
The Code Cage - Microsoft Office help

Notices

Microsoft Excel Forum Members Post questions in this forum if they are related to using Microsoft Excel, this includes Worksheet Functions, Excel VBA Programming, Simple Macro Code & Charting, Excel formula etc.

 
 
Thread Tools Rate Thread Display Modes
  #1  
Old 1st June 2010, 19:10
tlynn's Avatar
tlynn
Newsgroup Contributor
 
Posts: n/a
Posts Per Day: 0
My Top Tip Count:
Default Drop Down Lists 2007
     Excel: Functions   


------ Register to get rid of these "In Post" ads! ------

Category: Excel: Functions   

I have followed all the steps in creating a drop down list in Excel 2007:

Created Named list on seperate sheet
goto the sheet that the drop down will be on and select the appropriate cell
Data > Data Validation > Allow:List > Source: =BlahList > Click "OK"

....And then, I get this message every time:

"The list source must be a delimited list, or a reference to single row or
column."

So. What am I doing wrong? Ive been to Youtube, and read numerous articles
on here about "Drop Down Lists" and still am having an issue with this one
feature. Thank you for your time and attention in this...




The Code Cage Advertisment
Advertisement
  #2  
Old 1st June 2010, 19:47
Roger Govier's Avatar
Roger Govier
Newsgroup Contributor
 
Posts: n/a
Posts Per Day: 0
My Top Tip Count:
Default Re: Drop Down Lists 2007

------ Register to get rid of these "In Post" ads! ------


Hi

It sounds as though your "blahList" is more than one column Wide.

--
-------
Regards
Roger Govier

"tlynn" <tlynn@discussions.microsoft.com> wrote in message
news:33770AE0-C0BE-4819-A6DD-AE9ACC6447D8@microsoft.com...
> I have followed all the steps in creating a drop down list in Excel 2007:
>
> Created Named list on seperate sheet
> goto the sheet that the drop down will be on and select the appropriate
> cell
> Data > Data Validation > Allow:List > Source: =BlahList > Click "OK"
>
> ...And then, I get this message every time:
>
> "The list source must be a delimited list, or a reference to single row or
> column."
>
> So. What am I doing wrong? Ive been to Youtube, and read numerous
> articles
> on here about "Drop Down Lists" and still am having an issue with this one
> feature. Thank you for your time and attention in this...
>
>
> __________ Information from ESET Smart Security, version of virus
> signature database 5164 (20100601) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>


__________ Information from ESET Smart Security, version of virus signature database 5164 (20100601) __________

The message was checked by ESET Smart Security.

http://www.eset.com






  #3  
Old 1st June 2010, 21:02
Max's Avatar
Max
Newsgroup Contributor
 
Posts: n/a
Posts Per Day: 0
My Top Tip Count:
Default Re: Drop Down Lists 2007

------ Register to get rid of these "In Post" ads! ------


Roger, a short Q. where the deuce is Insert>Name>Paste List in xl2007? where
we can immediately paste a list of defined names (to check for example).
Thanks
--
Max
Singapore
---




The Code Cage Advertisment
Advertisement
  #4  
Old 1st June 2010, 22:09
Roger Govier's Avatar
Roger Govier
Newsgroup Contributor
 
Posts: n/a
Posts Per Day: 0
My Top Tip Count:
Default Re: Drop Down Lists 2007

------ Register to get rid of these "In Post" ads! ------


Hi Max

Formulas tab>Define Name or Formulas tab>Name Manager>New
or as a shortcut
Alt+M+M+D
--
-------
Regards
Roger Govier

"Max" <demechanik@yahoo.com> wrote in message
news:241CA0E3-FE6F-4B2C-B1A7-51E522F9D477@microsoft.com...
> Roger, a short Q. where the deuce is Insert>Name>Paste List in xl2007?
> where
> we can immediately paste a list of defined names (to check for example).
> Thanks
> --
> Max
> Singapore
> ---
>
>
> __________ Information from ESET Smart Security, version of virus
> signature database 5164 (20100601) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>


__________ Information from ESET Smart Security, version of virus signature database 5164 (20100601) __________

The message was checked by ESET Smart Security.

http://www.eset.com






  #5  
Old 2nd June 2010, 00:06
Gord Dibben's Avatar
Gord Dibben
Newsgroup Contributor
 
Posts: n/a
Posts Per Day: 0
My Top Tip Count:
Default Re: Drop Down Lists 2007

------ Register to get rid of these "In Post" ads! ------


I have not been able to find that feature either.


Gord

On Tue, 1 Jun 2010 13:00:01 -0700, Max <demechanik@yahoo.com> wrote:

>Roger, a short Q. where the deuce is Insert>Name>Paste List in xl2007? where
>we can immediately paste a list of defined names (to check for example).
>Thanks





  #6  
Old 2nd June 2010, 00:10
Gord Dibben's Avatar
Gord Dibben
Newsgroup Contributor
 
Posts: n/a
Posts Per Day: 0
My Top Tip Count:
Default Re: Drop Down Lists 2007

------ Register to get rid of these "In Post" ads! ------


That's fine for creating names

But I can't find a "paste List" anywhere.

Like in 2003 Insert>Name>Paste


Gord

On Tue, 1 Jun 2010 22:03:02 +0100, "Roger Govier"
<roger@technology4nospamu.co.uk> wrote:

>Hi Max
>
>Formulas tab>Define Name or Formulas tab>Name Manager>New
>or as a shortcut
>Alt+M+M+D





The Code Cage Advertisment
Advertisement

To stop seeing these ads and get other benefits check This page!

  #7  
Old 2nd June 2010, 01:15
Mike Middleton's Avatar
Mike Middleton
Newsgroup Contributor
 
Posts: n/a
Posts Per Day: 0
My Top Tip Count:
Default Re: Drop Down Lists 2007

------ Register to get rid of these "In Post" ads! ------


Gord -

In Excel 2007 and 2010, select the top left cell of an empty area, and
choose Formulas > Use in Formula > Paste Names > Paste List.

- Mike
http://www.MikeMiddleton.com


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:df4b065815mrq774nfoolc68squj53kpso@4ax.com...
> That's fine for creating names
>
> But I can't find a "paste List" anywhere.
>
> Like in 2003 Insert>Name>Paste
>
>
> Gord
>
> On Tue, 1 Jun 2010 22:03:02 +0100, "Roger Govier"
> <roger@technology4nospamu.co.uk> wrote:
>
>>Hi Max
>>
>>Formulas tab>Define Name or Formulas tab>Name Manager>New
>>or as a shortcut
>>Alt+M+M+D

>




  #8  
Old 2nd June 2010, 01:29
Gord Dibben's Avatar
Gord Dibben
Newsgroup Contributor
 
Posts: n/a
Posts Per Day: 0
My Top Tip Count:
Default Re: Drop Down Lists 2007

------ Register to get rid of these "In Post" ads! ------


Thank you Mike.

"Use in Formula" is grayed out on Bar if no names have been defined.

Too faint for these old eyes.

Max...............you see this?


Gord


On Tue, 1 Jun 2010 17:12:24 -0700, "Mike Middleton"
<Mike@DecisionToolworks.com> wrote:

>Gord -
>
>In Excel 2007 and 2010, select the top left cell of an empty area, and
>choose Formulas > Use in Formula > Paste Names > Paste List.
>
>- Mike
>http://www.MikeMiddleton.com
>
>
>"Gord Dibben" <gorddibbATshawDOTca> wrote in message
>news:df4b065815mrq774nfoolc68squj53kpso@4ax.com...
>> That's fine for creating names
>>
>> But I can't find a "paste List" anywhere.
>>
>> Like in 2003 Insert>Name>Paste
>>
>>
>> Gord
>>
>> On Tue, 1 Jun 2010 22:03:02 +0100, "Roger Govier"
>> <roger@technology4nospamu.co.uk> wrote:
>>
>>>Hi Max
>>>
>>>Formulas tab>Define Name or Formulas tab>Name Manager>New
>>>or as a shortcut
>>>Alt+M+M+D

>>





  #9  
Old 2nd June 2010, 09:17
Roger Govier's Avatar
Roger Govier
Newsgroup Contributor
 
Posts: n/a
Posts Per Day: 0
My Top Tip Count:
Default Re: Drop Down Lists 2007

------ Register to get rid of these "In Post" ads! ------


Sorry, Gord and Max
Didn't read the bit about Paste List.
Fortunately Mike read the question correctly and gave you the answer.

--
-------
Regards
Roger Govier

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:df4b065815mrq774nfoolc68squj53kpso@4ax.com...
> That's fine for creating names
>
> But I can't find a "paste List" anywhere.
>
> Like in 2003 Insert>Name>Paste
>
>
> Gord
>
> On Tue, 1 Jun 2010 22:03:02 +0100, "Roger Govier"
> <roger@technology4nospamu.co.uk> wrote:
>
>>Hi Max
>>
>>Formulas tab>Define Name or Formulas tab>Name Manager>New
>>or as a shortcut
>>Alt+M+M+D

>
>
> __________ Information from ESET Smart Security, version of virus
> signature database 5164 (20100601) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>


__________ Information from ESET Smart Security, version of virus signature database 5164 (20100601) __________

The message was checked by ESET Smart Security.

http://www.eset.com






The Code Cage Advertisment
Advertisement
  #10  
Old 2nd June 2010, 13:17
Max's Avatar
Max
Newsgroup Contributor
 
Posts: n/a
Posts Per Day: 0
My Top Tip Count:
Default Re: Drop Down Lists 2007

------ Register to get rid of these "In Post" ads! ------


Aha! so that's where its hidden, Gord.
My thanks to Mike as well
--
Max
Singapore
---
"Gord Dibben" wrote:
> Thank you Mike.
>
> "Use in Formula" is grayed out on Bar if no names have been defined.
>
> Too faint for these old eyes.
>
> Max...............you see this?





The Code Cage Advertisment
Advertisement
 
The Code Cage at Facebookhe Code Cage at Twitter


Tags
2007, drop, lists

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

The Code Cage Affilliates



http://www.thecodecage.com/forumz tested by McAfee Security http://www.thecodecage.com/forumz tested by McAfee Security

All times are GMT +1. The time now is 05:13.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Template-Modifications by TMS
No part of this board, functionality or creatives may be copied or reproduced either in part or full without the express permission of The Code Cage Team.
Copyright ©2008 - , Simon lloyd.
We are not associated with nor employed by Microsoft in any way, we simply provide resources!
All MS office icons are registered trademarks of the application they represent and are used with permission from Microsoft
UA-8135493-1
Cultural Forum | Study at Malaysian University
X vBulletin 3.8.7 Debug Information
  • Page Generation 0.20838 seconds
  • Memory Usage 6,493KB
  • Queries Executed 17 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footerEnd
  • (1)ad_footerStart
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_headerEnd
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_leftcolumn_code
  • (1)ad_navbar_below
  • (5)ad_postbit_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (10)helpful_answers
  • (1)helpfulanswers_javascript
  • (1)navbar
  • (3)navbar_link
  • (3)navbar_noticebit
  • (52)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_ctoptip
  • (10)postbit_wrapper
  • (1)showthread_changepostsowner_link
  • (1)showthread_extra_fields
  • (1)showthread_quickreply_mrgdp
  • (1)showthread_reason_popup
  • (1)spacer_close
  • (1)spacer_open
  • (1)su_form
  • (3)tagbit
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_datastore.php
  • ./includes/class_hook.php
  • ./awcoding/plugins/awc.php
  • ./awcoding/plugins/ds.php
  • ./awcoding/plugins/ss.php
  • ./includes/functions_notice.php
  • ./mobiquo/smartbanner.php
  • ./mobiquo/include/classTTConnection.php
  • ./mobiquo/smartbanner/head.inc.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/vbatags.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php
  • ./includes/functions_misc.php
  • ./includes/functions_prefix.php 

Hooks Called:
  • init_startup
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • fetch_musername
  • notices_check_start
  • notices_check_criteria
  • notices_noticebit
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • helpfulanswers_showthreadorpost
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • helpfulanswers_show_normal
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • error_fetch
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete