Pick From List

Feb 19th, 2002, 02:18 PM

Is there a way to modify what appears when you right click a cell and choose "pick from list..."? For example, could I enter a custom list somewhere on another sheet and have those values appear when I right click and choose "pick from list"?

Anne Troy · Feb 19th, 2002, 02:21 PM

Create your list anywhere in your workbook, preferably in a column by itself and starting in row 1. After you've created your list, select that entire column. Hit Insert-Name-Define and give it a name like MyList.

Where you would like a list, select the cell, hit Data-Validation. Choose List from the dropdown. In the context box below, type:

=MyList

Jack in the UK · Feb 19th, 2002, 03:57 PM

Hi

I liked this question so have ghad a play and sadly no better way that Dereamboats comments they are spot on ..

Only other idea i have was VBA to target and have popup box if say cell value / text = Jack in the UK (or whatever)to select cell text / value in say radio buttonor ballon fashion (looks nicer) but then though silly idea. Maybe no so .... errmmm i sleep on that one.. poss not so silly after all.

HTH
Rdgs
----------
Jack

Feb 19th, 2002, 05:08 PM

Thanks DreamBoat - your suggestion works beautifully. I was going to say it worked "just dreamy", but didn't have the nerve - thanks!

sann0638 · Aug 2nd, 2002, 04:46 AM

Dreamboat gives an excellent tool that I felt needed highlighting for anyone that hadn't seen it - it also highlights how use of MrExcel's search function works wonders.

Aladin Akyurek · Aug 2nd, 2002, 05:21 AM

Quote:

On 2002-08-02 03:46, sann0638 wrote:
Dreamboat gives an excellent tool that I felt needed highlighting for anyone that hadn't seen it - it also highlights how use of MrExcel's search function works wonders.

Mike,

That Search function appears to me to be slightly biased.

[ This Message was edited by: Aladin Akyurek on 2002-08-02 04:21 ]

Aug 2nd, 2002, 04:46 AM	#5
sann0638 Board Regular Join Date: Mar 2002 Posts: 175	Dreamboat gives an excellent tool that I felt needed highlighting for anyone that hadn't seen it - it also highlights how use of MrExcel's search function works wonders. __________________ Regards, Mike.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 19th, 2002, 02:18 PM	#1
Guest Posts: n/a	Is there a way to modify what appears when you right click a cell and choose "pick from list..."? For example, could I enter a custom list somewhere on another sheet and have those values appear when I right click and choose "pick from list"?

Feb 19th, 2002, 02:21 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Create your list anywhere in your workbook, preferably in a column by itself and starting in row 1. After you've created your list, select that entire column. Hit Insert-Name-Define and give it a name like MyList. Where you would like a list, select the cell, hit Data-Validation. Choose List from the dropdown. In the context box below, type: =MyList

Feb 19th, 2002, 03:57 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi I liked this question so have ghad a play and sadly no better way that Dereamboats comments they are spot on .. Only other idea i have was VBA to target and have popup box if say cell value / text = Jack in the UK (or whatever)to select cell text / value in say radio buttonor ballon fashion (looks nicer) but then though silly idea. Maybe no so .... errmmm i sleep on that one.. poss not so silly after all. HTH Rdgs ---------- Jack

Feb 19th, 2002, 05:08 PM	#4
Guest Posts: n/a	Thanks DreamBoat - your suggestion works beautifully. I was going to say it worked "just dreamy", but didn't have the nerve - thanks!