Combo Box #10

Can someone give me a lame, dummy version on how to create 
a combo box in a cell that has a list and shows the answer 
selected at the top?  I also need my formulas to be able 
to count how many times a given answer was chosen in the 
box.

If not, that's ok.  
0
anonymous (74717)
7/31/2004 7:43:11 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
699 Views

Similar Articles

[PageSpeed] 25

Brandy:

Both of the questions you're asking are pretty straightforward.  Here goes:

1)  The combo box.  First thing is to choose a range ON THE SAME WORKSHEET that contains the values you want for your combo box.
2)  Once you have those cells filled out, go to the first cell where you want to have the combo box.
3)  Go to your Data menu, and choose "Validation."
4)  Under "Allow," choose "List."  
5)  You'll then be prompted to select the cells, just as if you were inserting a function.  Select the cells from Step 1.
6)  You'll then see a combo box in the cell.  If you want to copy the combo box to additional cells, do this:
      a)  Copy the cell that has the combo box
      b)  Select the cells where you want to put it
      c)  Go Edit->Paste Special, and choose "Validation."

Now, for part two of your question - how to figure out how many times an answer was chosen:

1)  Go to the last cell in the range(if you had the answers in rows 1-10, for example, you could go to row 11.)
2)  Go Insert->Function
3)  Choose the function type Statistical.  The function you want is called "COUNTIF."
4)  The first argument is the range of cells you want to count.  For example, if the answers were in A1:A10, then the first argument would be A1:A10.
5)  The second argument is the answer.  For example, if the four answers were Red, Blue, Green, and Yellow, then the second argument might be "Yellow."  It is important to put the word in quotes.  Case, however, is not important.
6)  Repeat the process as many times as you need to for the other answers.  If you have multiple answers you want to count in the same range, consider doing an absolute reference ($A$1:$A$10, for example) in the function's first argument, so if you copy and paste the Yellow formula for the other colors, then it keeps the same cells.

Don't put yourself down...you're not lame or a dummy.  Everyone has to learn this.  Good luck.

Cheers,
Geoff Lilley
MCDST, Microsoft Office Master Instructor (2000/XP), Microsoft Office Specialist Master (2000/XP)
geofflilley@yahoo.com


"Brandy" wrote:

> Can someone give me a lame, dummy version on how to create 
> a combo box in a cell that has a list and shows the answer 
> selected at the top?  I also need my formulas to be able 
> to count how many times a given answer was chosen in the 
> box.
> 
> If not, that's ok.  
> 
0
Lilley (2)
7/31/2004 8:29:01 PM
Thanks Geoff, I appreciate it.
>-----Original Message-----
>Brandy:
>
>Both of the questions you're asking are pretty 
straightforward.  Here goes:
>
>1)  The combo box.  First thing is to choose a range ON 
THE SAME WORKSHEET that contains the values you want for 
your combo box.
>2)  Once you have those cells filled out, go to the first 
cell where you want to have the combo box.
>3)  Go to your Data menu, and choose "Validation."
>4)  Under "Allow," choose "List."  
>5)  You'll then be prompted to select the cells, just as 
if you were inserting a function.  Select the cells from 
Step 1.
>6)  You'll then see a combo box in the cell.  If you want 
to copy the combo box to additional cells, do this:
>      a)  Copy the cell that has the combo box
>      b)  Select the cells where you want to put it
>      c)  Go Edit->Paste Special, and choose "Validation."
>
>Now, for part two of your question - how to figure out 
how many times an answer was chosen:
>
>1)  Go to the last cell in the range(if you had the 
answers in rows 1-10, for example, you could go to row 11.)
>2)  Go Insert->Function
>3)  Choose the function type Statistical.  The function 
you want is called "COUNTIF."
>4)  The first argument is the range of cells you want to 
count.  For example, if the answers were in A1:A10, then 
the first argument would be A1:A10.
>5)  The second argument is the answer.  For example, if 
the four answers were Red, Blue, Green, and Yellow, then 
the second argument might be "Yellow."  It is important to 
put the word in quotes.  Case, however, is not important.
>6)  Repeat the process as many times as you need to for 
the other answers.  If you have multiple answers you want 
to count in the same range, consider doing an absolute 
reference ($A$1:$A$10, for example) in the function's 
first argument, so if you copy and paste the Yellow 
formula for the other colors, then it keeps the same cells.
>
>Don't put yourself down...you're not lame or a dummy.  
Everyone has to learn this.  Good luck.
>
>Cheers,
>Geoff Lilley
>MCDST, Microsoft Office Master Instructor (2000/XP), 
Microsoft Office Specialist Master (2000/XP)
>geofflilley@yahoo.com
>
>
>"Brandy" wrote:
>
>> Can someone give me a lame, dummy version on how to 
create 
>> a combo box in a cell that has a list and shows the 
answer 
>> selected at the top?  I also need my formulas to be 
able 
>> to count how many times a given answer was chosen in 
the 
>> box.
>> 
>> If not, that's ok.  
>> 
>.
>
0
anonymous (74717)
7/31/2004 8:53:36 PM
Reply:

Similar Artilces:

List box
I am trying to use the list box function from the control toolbar. I am not sure how to get the listings I want in the list box. Is there certain VB coding that is needed? Any help will be appreciated. Thanks. Todd No VBA code needed. In Design mode, click on your list box and select Properties from the Control toolbox (or right-click your list box and select Properties), then scroll down to the ListFillRange Property and indicate the cell range address that has the items you want to appear in the box (i.e., A1:A10). Then exit out of design mode and test your list box. MRO "Tod...

Re: Importing Messages Into Mail.app 03-31-10
In article eA#TMaJ0KHA.348@TK2MSFTNGP02.phx.gbl, Michel Bintener at mbintener@NOmvpsSPAM.org wrote on 3/31/10 1:53 AM: > On 30/03/2010 23:48, Rick O'Shey wrote: >> Per your original suggestion, I'll try the rebuild first. I'll let you know >> if it resolves the problem. > > Ok. > >> BTW: What time zone are you in? > > CET. Well, I just got done rebuilding the database and importing Entourage into Mail.app, and the results are the same: Only the first folder and its subfolders contain any messages; the other folders and their...

how do i view different mail boxes
I have set up different email accounts in outlook 2000. How do I choose which mail box I view when I go to outlook? btoonhoule <btoonhoule@discussions.microsoft.com> wrote: > I have set up different email accounts in outlook 2000. How do I > choose which mail box I view when I go to outlook? Using IMO or C/W mode? -- Brian Tillman ...

Concatenate Multi-Select List Box Items
I need to use the chosen items in a multi-select List Box as concatenated text in another control on a subform. This text will be part of a large amount of concatenated text. How do I do this? I did find info here about using such items in a query but it was way over my head and I couldn't figure out how to convert that idea to this issue so please don't just refer me to that w/o some other explanation for this novice. For example, if the user selects: Frt Bumper, Grille, & Headlamp in the List Box, I want to then somehow concatenate those selections into a sente...

Filtering a combo box using a combo box
All, I am trying to filter the records from a table displayed in a combo box using a combo box on the same form. I built a query and set the criteria as Me![FormName]![Combo_box]. This allowed me to filter the list, but it did not do exactly what I wanted. When the first combo box is blank, the second one is also blank. Is there anyway I can get the second combo box to display all of the records when the first box is blank? Thank you for your help. Regards, John Try a criteria in the second combo of: Like Forms!YourFormName!Combo1Name & "*" -- Arvin Meyer, MCP, MVP http:/...

email server 05-27-10
how do i find out what my email server is It's usually what is after the @ sign in your address. -- Bruce Hagen MS-MVP [Mail] Imperial Beach, CA "kyle valle" <kyle valle@discussions.microsoft.com> wrote in message news:19102D3B-F4DF-4BD1-8C02-451F80E8030D@microsoft.com... > how do i find out what my email server is Your email account provider has that information. They should have a help page on their website. If you tell us who provides your email account, perhaps someone can assist you. -- Dave N. MS-MVP (Mail...

colour change of dated box
How can I change the colour of a dated box of excel after the date is over. I want the programme to read date automatically from pc and change colour. try Conditional Formatting In 2003: 1. Select the cells you want to format 2. Choose Format, Conditional Formatting 3. Choose Cell Value Is from the first drop down 3. Choose Formula is from the first drop down 4. Choose less than 5. In the third box, enter =TODAY() 6. Click the Format button 7. Choose a color on the Patterns tab (or any available option) 7. Click OK twice. -- Hope this is helpful Appreciate that you provide your feedbac...

Combo Box on Forms
Hi, I am using a combo box on a form that has several items w/ one being Other. If the user selects other I want them to be able to input what they want so that it will go into the table instead of just the "Other". I just am not really sure on how to do that. Can you help? Thanks, Jaime In design view click on VIEW - Properties and the the combo. Then change Limit To List to No. -- KARL DEWEY Build a little - Test a little "jseger22@yahoo.com" wrote: > Hi, > > I am using a combo box on a form that has several items w/ one being > Other. If the use...

sent box
how do i get the emails in the sent box to show sent to instead of sent from? -- deb deb wrote: > how do i get the emails in the sent box to show sent to instead of sent from? Add/remove whatever columns you want. Right-click on the header row and select Field Chooser. i may have not explained myself too well i dont want to sort by the "to" column i want the header on the email to show "to" not "from" i think the problem might be that this is not the default sent file, its just a folder named "sent" its for my boss, he ha...

Regular Workbooks vs. Binary Workbooks 04-27-10
Can you tell me the difference between a regular Excel workbook and a binary workbook? We use a shared workbook as a tracking system for our department, and we often have conflicts, crashes, or other miscellaneous catastrophes. My manager was wondering if saving it as a binary workbook might reduce the number of problems that we experience. Thank you for your help. ...

Combo Boxes
Someone sent me an Excel document where each of the cells in I1:I312 are combo boxes. When you click off of those cells, the down arrow disappears. The list for the combo boxes are cells AA1 and AB1 (AA1 is New and AB1 is Existing). Please explain how this was done? Also, can you please tell me if it is possible to make New and Existing autocorrect entries. So even though the choices are New and Existing, if you hit N, New appears, and if you hit E, Existing appears. Thanks!! It sounds like Data|Validation. Take a look at Debra Dalgleish's site: http://www.contextures.com/xlDataVa...

Device Cannot Start (Code 10)
XP Pro on Dell XPS 630i After fruitless searches for my problem I come to this group. My Nvidia 8800 GT Card (1 year old) will not start no matter what updates I get. Still the constant "This Device Cannot Start-(Code 10)" I've pulled it out put it back in, Nanda! The lines are driving me nuts!! Any help in this matter? I've uninstalled the device, re-installed it. The card works on my other older Dell...Everything was fine until I wiped the drive and reinstalled Windows XP Pro. Anyone else out there have this problem? -- Netmanxps Try asking them here. ...

Separator in combo box
hi, Is it possible to have a line separator in a combo box? I mean something like a separator in menus? thanks, Behzad Try :- http://www.codeproject.com/combobox/zsepcmb.asp http://www.codeproject.com/combobox/customcombo.asp -- Regards, Nish [VC++ MVP] http://www.voidnish.com /* MVP tips tricks and essays web site */ http://blog.voidnish.com /* My blog on C++/CLI, MFC, Whidbey, CLR... */ "behzad" <b@b.com> wrote in message news:%23fVB3em5EHA.3368@TK2MSFTNGP10.phx.gbl... > hi, > Is it possible to have a line separator in a combo box? I mean something > like...

Edit box should support languages like japanese,chineese etc
Hi wht im trying to ask is.. 1. In my application, all the labels r in english only. 2.If i change the content of one text box in japanese or chineese language , [Text box value is the title for another dialog] 4.After i changed the content, i want the title to be displayed in japanese or chineese language. Note: I want only that text box to be changed ,,not the entire application.. so How can i able to support multibyte characters in MFC controls CEdit --text boxes.. Plz reply They do. You have to be in a Unicode app, and you have to have selected a Unicode font that has Chin...

Sorting a list of numbers 06-04-10
I have inherited an excel file with numbers across 100 columns and over 300 rows with several blank cells (likely 15%). I would like to format these numbers across 10 columns and however many rows are necessary, but without any blank cells, in ascending order down each column. Can someone help me how to do this? Thank you. sample? -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett@gmail.com "BRB" <BRB@discussions.microsoft.com> wrote in message news:93FADDD2-E412-4F09-AA3B-BD42E8345325@microsoft.com... >I have inherited an excel file with ...

Upgrade to 10 failed
I have been trying to get the upgrade from 8.5 to 10 to work. It appeared that the upgrade worked but when I go into utilities I get the following message: Field Service Unable to get extended version information for product 949. I have gone through KB952054 as well as the artilce on how to restart the upgrade. I have removed the software, reinstalled, did not put the SP4 and tried. No success! Can anyone help? Please? -- SC Remove that series from your set files before launching utilities so that you are able to upgrade the tables. You should be able to go in after...

Text boxes on graphs
How do you make a text box hide the grid lines behind it on a graph? The grid lines are still visible and run through the text box, cluttering it up. Thanks right-click text box choose -- 'Format Text Box' from shortcut menu colors and lines tab change fill color to white Warm Regards, Crystal remote programming and training Access Basics 8-part free tutorial that covers essentials in Access http://www.AccessMVP.com/strive4peace * (: have an awesome day :) * Drew wrote: > How do you make a text box hide the grid lines behind it on a graph? The > grid line...

Multiple Combo Boxes Highlighted
Hi, I have a problem with something in VB6. I have 4 combo boxes with individual names (not an array) located on an SSTab object. When I select another tab and then return to the tab these boxes are located on, each of them appears to be highlighted in blue. I add values to them only when loading the form so I'm at a loss as to why this happens ? Any ideas are greatly appreciated. Thanks, Jen. "Jennifer Ward" <jward@comcast.net> wrote in message news:eq5HrcBrKHA.6064@TK2MSFTNGP02.phx.gbl... > Hi, > > I have a problem with someth...

HELP !! Combo box to feed other combo boxes
Hi, I have a form with a stock list. One field is [Dealer Allocated] so stock can be allocated to a specific dealer - this is a combo box (combo1) for single allocations. I now also want to be able to update this combo box for several records in bulk. I thought I would do this by having a second combo box in the footer of the form which the user selects the dealer from and then clicks a button which looks for first record without dealer allocated and updates the value of combo1 to the value of combo2. This would then be enclosed in a Do Loop for specified number of records. I can...

Set Text Box Control To Blank
I have a procedure that executes on the beforeupdate event of a textbox (text24). The procedure works out the checkdigit for the number entered and if there is a discrepancy, a message box appears telling the user the number is wrong. What I'd like to do is modify the code as such so that when a discrepancy is found and the user clicks ok on the message box, focus is returned to (text24) and set to blank so that the faulty number is gone. Here is the code I am using.... It's quite crude as I'm only at beginner level, but hey, it works! Private Sub Text24_BeforeUpdate(Cancel As Int...

Entourage signature 01-26-10
Version: 2004 My signature does not show up when I reply to an email? HELP! This is a multi-part message in MIME format. ------=_NextPart_000_00DC_01CA9ED2.40209B80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Switch my reply/signature placement in a message: <http://www.entourage.mvps.org/faq_topic/reply.html#reply2> <helen_long@officeformac.com> wrote in message = news:59bb1a6a.-1@webcrossing.JaKIaxP2ac0... Version: 2004 My signature does not show up when I reply to an email? = HELP! ------=_Next...

text box margin settings
I've changed the text box margins, saved the file and closed the file. But when I reopen the file, the changes are not there. What gives?!? don The text box margins in an EXISTING text box have changed? Brian Kvalheim Microsoft Publisher MVP http://www.kvalheim.org >-----Original Message----- >I've changed the text box margins, saved the file and >closed the file. But when I reopen the file, the changes >are not there. What gives?!? > >don >. > This issue is unknown in Publisher any version. If you mean it is not saving the defaults on next Text F...

Flag box
Is it possible to add some flagbox in a column? How? Thanks Rossella Depends on what you mean by a flagbox. If you mean some sort of indicator, you could put Y or N in a column (X or leave empty??) and use data|filter|autofilter to "flag" certain entries. Rossella wrote: > > Is it possible to add some flagbox in a column? > How? > Thanks > Rossella -- Dave Peterson I meant the square with the x on it ..sorry if my explanation wasn't enough I find this technique pretty easy... Select the range Format|cells|number tab|custom category In the "type:&qu...

Populate field based on combo box
I know this shouldn't be so hard - but I'm having a brain ... or something! On a form, I would like to select a District Number from a combo box and have the District Name appear in a text field. My form is based on a query. I know somehow I need to add criteria to my query to point to the info in the combo box but I'm not sure exactly where to put this criteria. Should the combo box field for the District Number on the form be based on the Districts table or is this the field that comes from the query? Or is it the District Name field that comes from the query? I have neve...

Macro Help #10
Hi, I have a problem creating a macro to cut and paste data from on spreadsheet to another. I have a large spreadsheet with a few thousand entries, which detail names and departments. One column has the name of the persons manger i it. What I would like to do is write a macro to sort the contents of th spreadsheet by manager, select the first group of entries (all thos reporting to the manager) cut them from the spreadsheet and paste the into a new one call call the new spread sheet "manager".xls Id like the macro to do this until no data is left in the origina spreadsheet. I&#...