Make Drop Down Box Bigger

Nov 7, 2007

how can i make the drop down box bigger to display my text?

heres my problem

View 14 Replies


Make List Of Combobox Bigger?

Mar 12, 2009

i found this example of a combobox at but I don't think it is for excel. Is there anyway I can use code to make it so my combobox's list will be like the picture so it shows all the words instead of cutting them off?'

View 5 Replies View Related

Make The Auto-filter Range Bigger Than 1000 Cells

Apr 5, 2009

Is there any way witch i can use to make the auto-filter range bigger than 1000 cells?

View 2 Replies View Related

Make Drop Down Menu

Feb 28, 2007

how to create a drop down menu and grab data from the other side. pls have a look for a while at my attachment to check it...has anybody can provide me the steps

View 12 Replies View Related

How To Make A Drop Down Box Populate Fields

Oct 16, 2008

I have a Drop down box on my main sheet with the options "plan 1" "plan 2" "plan 3" etc... these options read from a list i setup on sheet 2 using the data validation list feature.

When i choose one of the plans from the drop down box I want it to populate the fields D13:D20 with data from more defined lists in the 2nd sheet.

View 9 Replies View Related

Formula: Make Drop Down Boxes

Aug 3, 2009

Column A - I want to make drop down boxes #1-30 - which would represent quantity
Column B- That will be 30 rows of dollar amounts
Column C - To be able to calculate the quantity x dollar amount

I'm able to create the drop down boxes with the numbers, but say I choose the number 5 by the dollar amount 200.00 It won't calculate 5 x 200.00....

I've been trying the formula you would use to find an average, and i've tried the if statments, but my drop down box isn't being recognized.

View 9 Replies View Related

Make A Drop Down List Show The Picture

Jan 2, 2007

I am trying to do, is make a drop down list show the picture above it. I have tried to change everything, and I am sure I am just a hair away from getting it right. I got the spreadsheet to where it will pull up the "Picture #" in the appropriate box, and even had it delete/hide all my pictures (I say delete/hide because I couldn't get them back after I removed the coding I was working on).

Another nice function I would like would be a button, around cell B74, to erase all the picks and reset the sheet for the next season... it would have to have a prompt to verify the user was absolutely sure they wanted to do that though! But I don't know where to begin on that button issue. Can someone point me in the right direction?

The spreadsheet is too big to attch, so it's hosted at the link below. The sheets involved are NFL Survivor & PicTable. On sheet PicTable, the Names & Pic #'s have already been named PicTable for ease of coding.

View 14 Replies View Related

Drop Down Lists: How To Make Source From Different Worksheet

May 13, 2009

When creating a drop-down list using Validation, is there any way to make the source a different worksheet in the workbook? Right now when I click on Source and select my list, it will not allow me to go to another worksheet.

If I manually enter a reference to cells in another worksheet, such as 'PCP'!$A$2:$A$250 it only shows that cited reference, not the actual list.

View 3 Replies View Related

Combo Box With A Yes Or No Drop But How Do You Make The Y A Default Always Entered

Dec 16, 2009

How do you make a Yes No combo box always have the default answer as Yes appearing on a user form but still allow the user to change it to NO?

View 9 Replies View Related

Drop-down Boxes Make File Size Too Large

Aug 31, 2009

I'm using Excel 2007. I have a cell with a dropdown box that has the values 1 thru 10. When I save the file (as an Excel 97-2003 compatible .xls file), it's 17kb which is normal. I want multiple dropdown boxes going down the same column, so that every time the user goes to the next row, another dropdown box will be displayed. I copied the cell with the dropdown box, selected the entire column, and pasted the dropdown box.

This time when I save the document, it's over 2MB in file size. I've seen other spreadsheets with several columns of dropdown boxes spanning thousands of rows and they stay under 30kb. I don't know what they did differently to keep their file size small. Why is my file size so large and how do I fix this? Do I need to use a 'paste special' function?

View 3 Replies View Related

Make Autofilter React Based Upon Selection In Drop Box...

Nov 14, 2008

I have a pricing model I'm working on where the request is to have all of the line/part items in the model, but only display a subset of those items based upon a sub-line chosen by the user by a drop box that includes all sub-lines.

Right now the list of parts is a table that I'm querying that also includes a simple '1' or '0' to indicate whether every part is an element of one or many sub-lines; eg (sorry, sure this won't format right):

Item SubA SubB SubC
210-1010 1 1 0
210-1011 1 0 1

So if choosing SubB in the drop box, I need the autofilter to show the first part, but not the second one. I think I have to do it this way (autofilter) because it will retain all of the parts whether the user is looking at them at this moment or not; they will use this tool to perhaps first price all SubB items, *then* go select SubC and price all of *those* items - and it needs to retain everything they've done, rather than a dynamic query that would lose prior changes and pull in a whole new set of data (if that makes sense).

So.... I need my autofilter to react not to specifically choosing data on the autofilter itself, but to a choice made in the drop box (probably a macro/VB attached to the box that reacts to the linked cell value that results from the choice, but I don't know how to tell it if the linked cell value is '5', go to column 7 (first two are part number and description) in the autofilter and filter on that column.

View 13 Replies View Related

How To Make Dynamic Drop Down Based On Static Cell

Sep 25, 2013

I am trying to send my field reps a spreadsheet that will allow them to pick the proper location for each building. The problem I am having is that there are ~45,000 buildings, each with anywhere from 1 - 92 locations. Here is how my spreadsheet is set up.

Sheet 1
Column B is where I want the drop down to be available for the rep to pick the location

Sheet 2
Column A has a list of the buildings
Column B has a list of the locations

I understand that normally I would need to create a named range for each building and its locations. However, there are more Buildings than columns in Excel. Is there a way I can do this using Index/Match, or Offset, or Indirect? I have a sample spreadsheet that can be found in my dropbox account using this link [URL]

View 6 Replies View Related

Can't Get The Box In Excel Bigger

May 25, 2014

As you can see in the picture, the box which I am writing in won't get bigger. I want it to cover the whole workscreen, but so far nothing has worked.

View 3 Replies View Related

IF Statement: Using Bigger Of Two Numbers

Jul 8, 2009

Sometimes my brain just fails me and I'm pretty sure this is a simple one:

In M5:

IF(ISBLANK(L5), (Use whichever number is greater: G5 or H5), (otherwise Subtract L5 from greater of G5 or H5))

View 4 Replies View Related

Embedded Bigger Than Smaller Than-IF

Jul 13, 2009

The jist of the problem is that employees are paid their normal wage up untill 37.5 hours of work. From 37.5 to 40 hours of work they are paid 1.5 times their wage. Any hours over 40 are paid at 2 times the regular wage.

So i need a formula that can work out their total pay. Im not sure what i could put in a dummy document to help you since it would just be one cell for their hourly wage, one for their hours worked and then one for the calculation. so you can reference any cell as an example and assume 6 as hourly rate

View 3 Replies View Related

Smallest Number In A List/Bigger Than X

Mar 30, 2007

Is there a forumula that will allow me to find the smallest number in A1:A10 that is also larger than the number in B1?

View 14 Replies View Related

File Gets Bigger After Deleting Data

Apr 10, 2007

I have a file about 13 Megs. I deleted a lot of data and saved it. It was 1 Meg bigger. I closed it, reopened, saved again. 700 k smaller than before, but still bigger than original. That is strange. There must be a way to get the dirt out.

View 9 Replies View Related

Created Validation Drop-down List - Can I Make The Row Now Change To The Colour That Relates To The Selection From The List

Jan 13, 2009

I am trying to create a fairly simple spreadsheet with about 8 columns and about 400 rows. One of the columns features a drop-down list with about 8 or 9 different options. Dependant on which option is selected, i would like the entire row to change colour with that option.

For example:
FAILED - whole row changes red
SUCCESSFUL - row has no fill
Tested - row changes to orange


Is this possible within Excel 2003?

View 9 Replies View Related

Find Two Closest Values In A List (bigger And Smaller)

Apr 9, 2014

I have a list with random ordered numbers (each number in a cell of a row): 1, 2, 6, 8, 11, 12, 16...

On the other hand I get a value (x). I want a formula that:
- If x is in the list, returns x
- If x is not in the list, returns the next higher value. For example, if x=8, returns 11

I want also a variation of the same formula, that returns the next lower value. For example, if x=8, returns 6.

Note that x will never be smaller than the first number on the list or higher than the highest number in the list.

View 1 Replies View Related

Make A Cell Look For Another Cell Value Then Call Up A Drop Down

Nov 30, 2007

Is there a way to create a multiple dropdown (Similar to Windows Start menu) so that the user can select the item and its properties then the selections be placed into multiple cells? For example, i select wood from drop down list and i get another drop down list asking for the type of wood, I select MDF and another drop down ask for thickness. when I finished my selections, then the selected Items copy themselves into 3 different cells.

I have a drop down in (A1) cell and I select an item from it. I want (A2) cell to check the name in (A1) then call up another drop down i already made in (A2).

View 10 Replies View Related

Lists, How To Make Drop-down Lists Optional

May 13, 2009

Is there a way to make a drop-down list optional? When I create drop-down lists the user has to make a choice from that list.

Example: a list of doctors. I need the user to be able to select from that list if the patient saw one of those physicians, but if the patient saw another doctor not on the list, I need the user to be able to enter the name of that other doctor. Currently the user has to select from the list or not enter a doctor. I am using Excel 2003.

View 2 Replies View Related

Make Userform Show Data From Spreadsheet And Add Delete Or Make New Entry

Jan 24, 2014

I have a spreadsheet on sheet 1 with a list of customers and their information. So on column A I have the customer number (i.e. k968, e37, p528,...), on column B i have the customer's name, on column C the street's name, on Column D the house number, on column E the zip code and finally the city on column F.

Right now there are around 600 customers in this list.

I have made a userform with a combobox in which I want to select an existing customer (pulled from the spreadsheet). On the same userform I have textboxes (customer number, name, street, number, zip, city). When I select a customer in the combobox, I want this customer's info to show up in the textboxes. I want to be able to change the info and hit Next to store the changes in the spreadsheet. When I do not select a customer from the combobox, I want to add new info in the textboxes and hit Next to store this info as a new customer. The userform also has a delete button. Then I select a customer in the combobox, this customer (and it's info) should be deleted from the spreadsheet when i hit Delete. So the spreadsheet is variable in length.

View 5 Replies View Related

What Its Called When You Have Drop Down Menus That Correspond With Other Drop Down Me

Nov 22, 2008

what its called when you have drop down menus that correspond with other drop down menus.

View 2 Replies View Related

Populate Drop-Down Based On Another Drop-Down Choice

Oct 25, 2006

Here is what I'm trying to do:

I have 4 sheets:
1 called main
1 called states
1 called counties
1 called people

On "main" I have 1 drop down box and 1 cell:

the drop down lists the states from "states" sheet
the cell, which i would like to have as a drop down is supposed to be listing the counties in the state selected from the 1st drop down. right now it is setting the value to TRUE for testing purposes.

then when the county is selected, it will display the people in that county listed in "people". So far I can only get the 1st drop down to list the states. that's the easy part. i need to getting the counties to list in another drop down based on what state is selected.

View 2 Replies View Related

Populate Drop-Down Based On Another Drop-Down Selection ...

Dec 5, 2007

Im a fairly basic VBA user who has just purchased the code for J-Walk's Enhanced Data Form.

On other threads in this forum I have noticed a lot of people asking how to make the contents of one drop-down box dependant on the selection in another. I am trying to do the same thing but with the criteria section of the EDF form.

Is this possible? What does give me hope is that a simple Autofilter - whilst not as aesthetically pleasing, does the job well.

View 3 Replies View Related

Populate Drop-Down Based On Another Drop-Down Selection

Aug 7, 2008

Currently I have columns fixed or assigned to the names of insurance providers/companies.

In each column below the name of the Insurance Company, a combobox containing the plans that company offers. Choose a plan, and the rest of the column is filled in using vlookup.

Now to save space, IE opposed to having 13-15 columns one assigned to each Insurance Company/Provider. I am looking to have only 3-5 columns with a first initial combobox in which one chooses the Name of the Company/Provider, and in turn populate the original combobox and vlookup functionality I already have built in.

Here is an example of what I am working with.

View 3 Replies View Related

Make Now () = 06/29/2009 (make To Cells With Dates Equal Each Other)

Jun 29, 2009

I need to figure a way to make to cells with dates equal each other if the
day,month and year are the same but are placed into a cell at different times during the day. "Making Date Now () = (06/29/09) In another cell". Therefore, A1= Now() and E11 = 06/29/09

View 2 Replies View Related

Drop Down List Which Returns Values Based On What Has Been Selected In The Previous Drop Down List In The Adjacent Cell

Mar 19, 2009

I'm trying to create a drop down list which returns values based on what has been selected in the previous drop down list in the adjacent cell, e.g. if 'Apples' is selected in the previous cell then you should only be able to select from 'Gala, Granny Smith', or if 'Oranges' is selected you should only be able to select 'Seville, Blood Orange'. Is there a formula which would do this, or can I use a pivot table somehow? I'm totally stumped.

View 2 Replies View Related

Selection From One Drop Down Creates New Drop Down

Mar 1, 2007

In the attached example I am trying to get the selections from one drop down to gnerate available selections in the next. The first drop down is the door style. This then needs to generate the possible drop downs in wood species. This then needs to generate the possible drop down in available stains. this then needs to generate the related door factor....

View 9 Replies View Related

Drop Down List Which Displays A Different Set Of Values Depending Upon The Value Selected By A Previous Drop Down List

Oct 26, 2009

I need to have a drop down list which displays a different set of values depending upon the value selected by a previous drop down list. ie. (drop down box 1)= x, y, z. (drop down box 2)= either x1, x2, x3, or y1, y2, y3, or z1, z2, z3. I can produce a single drop down box thats not a problem but linking several drop down boxes is beyond me .

View 4 Replies View Related

Copyrights 2005-15, All rights reserved