list box

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'...

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...

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"...

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...

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...

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...

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...

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...

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...

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...

Hello, I am running Excel 2010 and Windows 7. I have been working on this project for several weeks and this problem has eluded me from nearly the beginning. See Photo I have a form with a main list box and several other list boxes. I drag and drop records from the main list box to the...

Here is an interesting one for you folks looking for a challenge: I have a table "RecurringINVReceipt" that resides on "sheet14" used to enter a list of inventory to be received that starts out empty for the user. I am running Excel 2010. Row 9 is the first non-header row of the table. Cell...

When I run the following code the values in the called sheet populate into the list box. However, when I try to click them on the user form sheet, the values disappear and I get a blank box. Can anybody help? Thanks! Private Sub Product_Change() Application.EnableEvents = False Product.Clear...

Hi Guys, I'm trying to figure out how to acheive something quite simple, but have become a little stuck... I'd like a dropdown box in A2 to select from a list of 2 products, then in B2 i'd like to be able to have a dropdown box to select the product variation. The products and variations will...

Hello: I have created two drop down lists. The first drop down provides seven options and then the second drop down gives options based on the first selection. After the second selection is made I have created a v-lookup below to display all information relating to this selection (around 10...

I currently have a set of ListBox controls on a worksheet tab. They are all configured as multi-select and i have the values populated via the ListFillRange properties. Each listbox has an '{All}' option; when the user clicks on this value I want to de-select all other previously selected...

I have a userform that has a listbox named Instructor. From the listbox the user can select multiple Instructors in the list. I want these selections to populate my spreadsheet. Right now it only populates the first item in the list no matter what selection is made. What am I doing wrong...

So I have a lot of text that I need to have in a cell. I thought having a list box would be a good idea because it allows you to scroll down and helps in keeping the information neat. The problem arises when I try using filters, the list boxes get all over the place. Does anyone know of a...

Hello all again, I have a form control listbox, which is populated with filenames from a specific directory. When the user selects an entry I need that text to appear in a cell in the workbook. This is then concatenated with a folder path to open the file to copy and paste some data out into...

Hi, I'm an absolute VBA novice and am stuck with some code that I've been give to output multi listbox selections into a single cell. I've searched for an age to find an explanation I can understand but failed miserably - please help me retain my sanity :banghead: Everything works well until...