combo boxes

  1. S

    Guidance on excel version/Combo boxs/Command Buttons

    Hi, There is a heavy induced macro template i use for work which tends to do alot. The version type is Excel 97-2003, but over time this macro has become nothing of a slogfest (Incredibly slow) When i convert this to the Excel 365 it seems like none of the Command buttons work as they arent...
  2. G

    Form Control Combobox Reset

    Hi All you Excel Guru's I need a little help. I am using four combo boxes from the Data Ribbon (Controls - Insert - Format Controls Combo Box (From Control). I would like to set it up that when the 1st combobox changes its selection that the other three reset. The problem is I am trying to...
  3. M

    If/Then Combo Boxes

    Hi, I can't seem to find a previous post close enough to what I'm trying to accomplish. Also, I don't know if this is possible with Excel formulas or if VBA must be used as well. Below I have an API that shows stock prices, volume, etc. Columns J and K have Combo Boxes and column N has Check...
  4. T

    Comparing Two Combo Box Selections

    Hi, I'm fairly new to coding in VBA and would like to make a cell that shows a string based on the input from two combo box integers. Something like if X is chosen in cboBoxA and Y is chosen in cboBoxB then "xxxxx" appears in cell C and so on. I'm also wondering how to populate these cbo boxes...
  5. S

    How to code dependent combo boxes on large amounts of data?

    First off thank you for your help in advance. I would like to use three different combo boxes to drill down into an analysis. Each combo box represents a level in a product hierarchy (For example, Department --> Category --> Subcategory). I would like the user to be able to select an option...
  6. R

    Auto update column when ComboBox selection is made

    I've been putting together a macro that reads in cells from one specific row on <CODE>Sheet1</CODE> and places them onto a ComboBox on a <CODE>Sheet2</CODE> <CODE>|cellA | cellB | cellC | cellD | ... |cellZ | </CODE> </PRE>Once loaded to the ComboBox, whatever cell is selected there has it's...
  7. R

    URGENT; Combo Box; change list to new FY

    The combo box I have still lists only FY12 Months. I need it to move the FY13. Code of the UserForm is this..... Private Sub cmdProcess_Click() monthIndex = cboMonth.ListIndex selectedMonth = Chr(cboMonth.ListIndex + 68) selectedMonthText = cboMonth.Text isEMOHasRoyalty =...
  8. R

    Combo box showing values based on another combo box selection

    Hi Without using VBA, I would like to have a Combo box showing values based on another combo box selection. E.G. The 1st box would have a list of Countries and when Country was selected, then the 2nd Combo box would show the appropiate Cities for that Country only. I have tried listing each...
  9. B

    Changing color of all combo boxes with VBcode

    Hello, Is there some code to change the fill color of all the combo boxes I have on a spreedsheet. Thanks:cool:
  10. U

    Take out diplicates in combo box

    Hello, I have created a form with a combo box. The combo box should only have 4 options (North America, Latin America, Europe and Asia). However, since the data behind the combo box is a query it shows ALL the lines of data and their option. So in my drop down list I have many North American...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top