list box

I am trying to create a dropdown list that when an item is selected in the dropdown, the cells to the right autofill with data related to that selected item. For example. If I click on a dropdown and choose "Wednesday" in Cell A, then in Cell B, C, and D, autofill with "work", "gym", and...

Surely someone has made dependent List Box (Form Controls) before? How is this done since you cannot use INDIRECT()? I've tried searching, but everyone references the Data Validation / Indirect method? I'm looking for something that would use the List Box Form Control. Thanks!

Here's the situation. I more or less have a tiny "database" (if you'd even call it that) that contains: Brands Products Descriptive Categories Each Brand (15) can contain anywhere from 2 to 30 different Products. Each Product, contains the same set of 15 Descriptive Categories. *** I...

Not* sure how to write code to filter through 5 worksheets.. I have 5 different listboxes on a userform. Each listbox shows days/times (two columns) options of different courses available. When the user selects one of the class options that he wants to take, all of the other options in that...

I'm using the code below to hide or unhide and activate worksheets in my workbook. I would like to add code to deselect the original selection in the listbox, however when I try to add code to several places I receive a Run-Time 9 error, subscript out of range. Private Sub lbSheets_Change()...

Hi all, I am using Excel 2003 running on XP. I have a routine that allows me to work on data held within a list created from data on a spreadsheet ("Income"). This works perfectly when there is data in the sheet. If the data sheet is empty (like after month end) then I get the following...

I have a workbook that contains a few lookup sheets and a userform. The userform has 2 option buttons and a listbox on the form as well as a create new button. When you click on an option the listbox should populate with a specific list of items found on a lookup worksheet in the same workbook...

How to Link ListBox1 to Cells on an Excel Worksheet (e.g. sheet5 named "SCORE SHEET")

Hi guys! I need help in populating my listbox with values from a worksheet. Here's the userform: And also, can you teach me how to ADD, EDIT, and DELETE selected items on the listbox. In a way that it'll be added, edited, and deleted in both the listbox and worksheet.

I have a drop down box in cell A6, which contains the name of ranges from another worksheet. I'm trying to add a list box that populates with the data from the named range selected in A6. I've tried setting the input range to A6, which populates the list box with whatever value was selected...

I have a userform I am working on that basically acts as an advanced filter. I am barely versed in vba so I put my mild skills to use by editing a template. One of the functionalities that it is missing is that I can't seem to get the filtered items that show up in the listbox to be clickable...

Hi, I've created a list box via the data validation section. I have a spreadsheet containing a list of names with various bits of data connected to them. What I'd like, within an overview work sheet, is click on a name within the list box whereupon is pulls through the relevant data from my...

Please pardon me if these seem like foolish queries, I've been using Excel for years, but the cat knows as much about VBA as I do. My issue: I am constructing a series of macros to format a complex input form that I'm designing to price projects. The macros hide various rows and worksheets if...

Hi, I have a excel spread sheet in excel 2007. I made a list of material in a drop down list by validating the list of material. I want to be able to select an item in the drop down menu and it list the item and then in the next cell beside it show the price the relates to the item selected and...

Hello Excel peeps, I've got an ActiveX ListBox (MultiSelectExtended select mode) with a state list. User can select multiple states, which I output into a cell with: (In Private Sub ListBox1_Change() ) Worksheets("Master - FUW").Range("States").Value = _ Join(lbSelectedItems...

Is there a way to display a selection box of available tabs that fit certain criteria to the user? I have a workbook that has up to 12 tabs. Most of which are data tabs extracted from a database that is used to populate the "Template" tab. I want to display a list of Template tabs in this book...

I really hope someone can come to my aid with this! I have a userform with the following on: I have a text box that the user enters a role name into. (txtRole) a text box where data is displayed (txtWinner) and a text box for the percentage (txtScore) a command button that says GO! (cmdGo) and...

I have a form that populates a list box and a combo box. My goal is to populate the list box according to my combo box but can't find the answer.

Hi Guys, I have a list box full of products and I know that you can enter the first letter of the product and it will skip to those products. I would like to take this a step further and be able to type part of or the full product name in a cell and have the list box skip to that product...

In Access 07, I have a list box in which I display values from a table, call it tblTable1. One value in tblTable1 is limited to a combo box showing acceptable values from tblTable2. In the list box on the form, however, I only get the numbers of the items instead of their values. I assume...