list box

  1. S

    Last Item in ListBox Causes All Item to be Removed

    For some reason the code below will end up deleting every item in the listbox when you select the last item in the list. If I select any other item besides the last item in the list it will only delete that selected item. Private Sub DeleteIngredientButton_Click() Dim Index As Integer...
  2. M

    List box values TO cell

    Hi, This question has no doubt been asked hundreds of times but for some reason I can't find it anywhere on google which is incredibly frustrating. I have a listbox (listbox1) with data in it and multiselect activated. I select multiple fields from this listbox selection and press OK. All I...
  3. F

    Pull Data From Two Tables

    I am attempting to match data (state and year) in two tables that have the same h row and v column headers by using 2 drop list State Year Population Cases Drop List Drop List Result From Table 1 Result From Table 2 Both tables would look similar to the following: Table 1 (Population)...
  4. R

    User Form: Timestamp and Buttons

    Hello! I'm new to vba in excel and understanding the language & i need help with my user form :confused: I have created a form that acts like a Log Form to track who goes into a room. In my form I have two command buttons that allow users to Submit Entry & Log Off. The Submit Entry button...
  5. K

    Application.Run"'Macrobook.xlsm'!" Listbox item that is selected

    Hi, I am just wondering if there is an easy way to run a macro based on the values within a listbox. E.g. I have four macros for four reports. I add the names of these reports into a listbox and select them as necessary. How do I then reference them in Application.run or Call? Item names /...
  6. W

    List Box Question Remove the 2 Auto Selected

    I have created a document that has a list box where the user selects the items and then adds them to a restricted section of of a Ammo Tab A27 - A71. when the user opens the form up with the list box there is 2 items automatically selected, how do I stop this. I have attached a link below with...
  7. N

    Trying to Replace a Combo Box with a List Box (Form Control) in Excel Worksheet

    Hello, I'm working with an excel worksheet with macros and there are several Combo Boxes (Form Control) on one worksheet. Most of these Combo Boxes have only 2 items to choose from so I thought it would be nicer to have List Boxes to replace them. I started by trying to replace just one combo...
  8. D

    Input via TextBox & Output in List Box

    Hi, How to display the inputs to list box. I have a text box which will ask the Product ID and everytime when i click the button add new one, the text box should become empty to get the next input and whatever input that i gave should get display in the list box. I tired to transfer the data...
  9. D

    How to display the values in listbox (input by textbox)

    Hi, I have form which will ask the product ID's. Whatever the user entering via text box should get displayed in list box. Example: Form with label "Enter the Product ID" and followed by a text box to get the input and three buttons "Add to the List" and "Delete from the List" and "Close". I...
  10. M

    How do you add IF-formulas in MS Access Table/Form List Box (or Auto-populate a list?)

    Hi! I'm new at using MS Access. My team needed a task tracker that would encompass various task groups so I decided to use a Task Management template to create an MS Access database. Under one task group, we have a number of sub-groups that currently keeps one excel file tracker each. For...
  11. N

    Help with lists

    Ok, so mine is pretty simple, but I haven't done it before and am getting stressed trying to look.. - I have Sheet 1 and 2. - Sheet 1 Cell 2A has a drop down list of data that is on Sheet 2 B1 - On Sheet 1 Cell 2B I want to be 'If Sheet 2 Cell B1 is selected then B2 goes in to Sheet 1 Cell 2B'...
  12. J

    Validation data across 5+ columns with multiple variables within each column

    I am trying to develop a rather robust engineering/architectural style hardware schedule using Excel and data validation tables. Due to the numerous options though, I feel that data validation tables will require far more maintenance than the benefit of developing this project. To work as well...
  13. M

    Conditional List Box using table as a source

    Hi everyone, I am hoping someone is able to help me. I want to create a data validation list using a table as a source for the data. My excel workbook has a table called "AllAssets" which contains various columns of data. i want a list box that will display only values from the "Asset Tag"...
  14. E

    Filtering Data

    Hey guys, I am new to VBA Macros and formulas within excel and I currently am struggling with my excel work. I would like to filter data using either a drop down box or combo box. My spreadsheet consists of students with different grades for the subjects that they do and this page is meant to...
  15. T

    Show/Hide Row Range Based on Cell Value

    Hello all and thank you for your assistance. I have searched forums thoroughly for a solution to my problem without success so seek your expertise for an answer. Situation I have a list box with the following 13 options: <colgroup><col></colgroup><tbody> Show All July 14 August 14...
  16. N

    Single ListBox Loop help needed

    Hi I have a worksheet with a single listbox. I need to loop through all the values in the listbox and make a PDF of the sheet. (The listbox items change all the values on the worksheet). I've searched and found some code that should work, but it isn't and I have no idea what is wrong. This is...
  17. G

    Excel 2007: List Box (ActiveX Control) with multiple columns?

    I am working on an electronic version of an existing paper form. The user must be able to make multiple selections from 18 choices. Each choice has a corresponding check box. I have a List Box (ActiveX Control) with the following properties set: ListStyle: 1 - fmListStyleOption MultiSelect: 1...
  18. K

    Combo box for both input and bound list

    I'm not knew to access but I'm very green at vba. I've created a database with two: 1 for putting in the initial incident and the other for the follow up comments. In the field for the person getting assigned to the comments on the first form it could be anyone in our company so I don't want to...
  19. P

    Using Multiple multi select Listboxes on a Form to query data (using a Command Button)

    I have recently posted on this forum asking how to use a multi-select list box on from to query data using a command button. I have since figured that code out and have it working. </SPAN> I now want to expand on this and want to be able to add in another multi-select list box on the same form...
  20. C

    VBA - Selected list box rows --> array, array --> worksheet. Please Help.

    Hello, I am running Excel 2010 and Windows 7. I've been working on this for quite some time, and I am stumped. Any help is appreciated. I have data on a hidden worksheet with three columns (A,B,C) and the number of rows varies but is typically a thousand or so. I paste data into this sheet...

Some videos you may like

This Week's Hot Topics

Top