combo box validation

  1. P

    data validation combobox userform

    Hi, I'm completely new to Access! I would like to add some data validation rules on to a combobox.. The combobox is linked to a table called "options" with a field called "products" Userform is called: Tracker Combobox is called: ProductType ProductType must equal "products" within the...
  2. lumch

    combobox

    Hello everyone, Honored to be here: a question.... I need a code to create a combobox that do this: 1. for example select GI esp. an then shows a list on a combobox a list of places that are specialist in this matter, but if I choose for example Radiologist it will show a list of places only...
  3. 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 =...
  4. F

    Macro won't work properly when I protect my sheet

    Hello All, Background info: I am working on Excel 2010 and running Windows 7 (64 bit). I have a worksheet that contains a macro to create data validation combo boxes (which is pretty neat since it gives the users the autofill function). I did not write this macro, but rather obtained it...
  5. G

    ComboBox with Data Validation

    Hi - I found a macro that displays a Data Validatoin Combo Box using Named Ranges. Right now, it works on ALL cells in the worksheet that have Data Validation, but I would like to customize it to work on only 1 cell (F6). I've tried to define the Target Range as F6, but I must be doing sth...
  6. K

    Adding multiple comboboxes to cells using VBA

    Hello all, I have created a matrix to help me priorities data collection of different datasets for a project I am working on. I have the same datasets listed horizontally and vertically so I have the same number of rows and columns. Within each cell the user the selects one of the two...
  7. H

    Combo Box selection to populate Form

    Hello I am working on a form where when a selection is made from a combo box the next box is populated automatically from information entered earlier in a worksheet (GolferDB). Specifically when the last name is selected from a combo box the first name appears in the next combo box...
  8. C

    Add Item to Combox in Userform

    Hi All, I've searched here and googled but to no avail. I'm not to savvy on this VBA stuff but have fumbled around and created a Userform with a ComboBox and several other fields in an Excel Workbook. The ComboBox gets its list of Customer names from a range in a worskeet...
  9. M

    Combo Box Query

    Hi, I am using a combo box on a userform that is linked to a range in my worksheet. Currently the user can type what ever they want into the combo box, even if it is not in my range. How can i validate the combo box so that the user is only able to select an entry from the drop down list...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top