| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
If the range is A2:A150 then type that in the listfillrange (click in the
box to the right of the word listfillrange and type it there then close the properties window) -- Regards, Peo Sjoblom "sparrot" <(E-Mail Removed)> wrote in message news  C0FE22F-3F83-467D-9FF5-(E-Mail Removed)...>I am not sure what you mean by "Put the range with your list in the >> listfillrange and the cell you want to link to" I got to that part and >> am stumped. > Thanks > > "Peo Sjoblom" wrote: > >> Office button > Excel Options, make sure "Show Developer Tab" is >> selected. >> Click the Developer tab > Controls > Insert Combobox from the active x >> controls, >> right click the drop down and select properties, in that pane that >> opens. >> Put the range with your list in the >> listfillrange and the cell you want to link to. Click the design mode >> button >> to get out >> of design mode >> >> >> -- >> >> >> Regards, >> >> Peo Sjoblom >> >> Excel 95 - Excel 2007 >> Northwest Excel Solutions >> www.nwexcelsolutions.com >> (Remove ^^ from email) >> >> "skittles_golf" <(E-Mail Removed)> wrote in message >> news:631A9566-9624-4C28-843C-(E-Mail Removed)... >> > How do you create a combo box in Excel 2007 >> > -- >> > Jenny >> > >> > >> > "Peo Sjoblom" wrote: >> > >> >> You can't using data>validation, you can if you use a combobox from >> >> the >> >> control toolbox >> >> >> >> >> >> -- >> >> Regards, >> >> >> >> Peo Sjoblom >> >> >> >> >> >> >> >> "skittles_golf" <(E-Mail Removed)> wrote in message >> >> news:91806D61-5E51-41E7-A12B-(E-Mail Removed)... >> >> >I have created several Drop Down boxes in a worksheet but I want to >> >> >make >> >> >them >> >> > visible so people know there is a drop down box there. Right now >> >> > the >> >> > arrow >> >> > doesn't show until you click on that cell. Please help I am not >> >> > quite >> >> > sure >> >> > how to format it so the drop down arrow stays. >> >> > -- >> >> > Jenny >> >> >> >> >> >> >> >> >> |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Hi Sparrot,
Why not add a comment to the appropriate cells and show the comment. Or you could format the cells with a different color file or a border, then teach your users what those formats mean. You could even conditional format the cells to have a color until the user picks an entry from them. Cheers, Shane Devenshire "sparrot" <(E-Mail Removed)> wrote in message news C0FE22F-3F83-467D-9FF5-(E-Mail Removed)...> I am not sure what you mean by "Put the range with your list in the >> listfillrange and the cell you want to link to" I got to that part and >> am stumped. > Thanks > > "Peo Sjoblom" wrote: > >> Office button > Excel Options, make sure "Show Developer Tab" is >> selected. >> Click the Developer tab > Controls > Insert Combobox from the active x >> controls, >> right click the drop down and select properties, in that pane that >> opens. >> Put the range with your list in the >> listfillrange and the cell you want to link to. Click the design mode >> button >> to get out >> of design mode >> >> >> -- >> >> >> Regards, >> >> Peo Sjoblom >> >> Excel 95 - Excel 2007 >> Northwest Excel Solutions >> www.nwexcelsolutions.com >> (Remove ^^ from email) >> >> "skittles_golf" <(E-Mail Removed)> wrote in message >> news:631A9566-9624-4C28-843C-(E-Mail Removed)... >> > How do you create a combo box in Excel 2007 >> > -- >> > Jenny >> > >> > >> > "Peo Sjoblom" wrote: >> > >> >> You can't using data>validation, you can if you use a combobox from >> >> the >> >> control toolbox >> >> >> >> >> >> -- >> >> Regards, >> >> >> >> Peo Sjoblom >> >> >> >> >> >> >> >> "skittles_golf" <(E-Mail Removed)> wrote in message >> >> news:91806D61-5E51-41E7-A12B-(E-Mail Removed)... >> >> >I have created several Drop Down boxes in a worksheet but I want to >> >> >make >> >> >them >> >> > visible so people know there is a drop down box there. Right now >> >> > the >> >> > arrow >> >> > doesn't show until you click on that cell. Please help I am not >> >> > quite >> >> > sure >> >> > how to format it so the drop down arrow stays. >> >> > -- >> >> > Jenny >> >> >> >> >> >> >> >> >> |
|
|
|
|
|||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Insert new row with drop-down box but problem with cell linkreferring to the original drop-down box | Phi| | Microsoft Excel Programming | 2 | 7th Jul 2010 12:22 PM |
| How do I create a drop down box within a drop down box? | sg | Microsoft Excel Worksheet Functions | 1 | 1st Apr 2010 03:15 PM |
| How do I add a drop down box within a drop down box? | auroraruth | Microsoft Excel Misc | 1 | 12th Jun 2008 09:34 PM |
| drop down box leading to another drop down box | =?Utf-8?B?c3R1bWFra2Vy?= | Microsoft Excel Misc | 2 | 12th Jan 2006 06:03 PM |
| New to .NET, can I have one drop down box control the data of another drop down box using a database? | SirPoonga | Microsoft ASP .NET | 2 | 7th Jan 2005 11:44 PM |
