list box

I've been working on a Survey template for a project at work. The workbook has multiple worksheets (1 for each question) and a series of repeating List Boxes for responses corresponding to multiple locations. Each list box is populated from a static named range on another worksheet...

Hello, I'm attempting to perform an update query to a table for the field "periodyear" and "period" using a text box and a list box that live on a form in front of the database. The text box's name is Year_Label and the list boxs name is Quarter_Label. I've had this working at one point where...

Hello all, I created a file that I want to send out to all employees in my company. In this file, I have three List Boxes (Active X Controls). I'm noticing when I email this file to other individuals in the company the size of the list box changes in relation to the rest of the Excel file...

Hi Guys, Really need someones help on this! I have a listbox "EventNameListBox" with contents displaying info on clothing etc that gets its info from Sheet2, all works well but I need is to filter the contents in the listbox even further. I need to filter the contents in the list box to display...

Trying to create a list box with values in a column = value . Using VBA I was able to cycle true the records = value...in trying to populate a list box with those field values...error...it seems an array was needed to be defined....found code and adapted to my logic and it populated list box...

Hi Guys, I have a form with 4 TextBoxe's "TexBox1,2,3 etc" and a ListBox1 were the whole idea is that you enter a value in TexBox1 and the VBA code looks for any and all items on your data "respective worksheet" and lists any/all data that it finds "corresponding to the value in TextBox 1" in...

Hi everyone, I would like users to be able to add values from a list that I have stored say in sheet 2 of my file. My document is a specification for a programming task, so the requester has to select the variables that they require...however they usually typo these or just dont do it right...

Hi I am a new user to form controls and VBA and I know most of you will be thinking I could search for the answer, but after around 4 hours of reading posts I am still a little confused and can't find what I'm looking for, as they all go a little more complex All I need is a List Box that...

The data validation lists i have in many cells in my spreadsheet disapear when I close excel. When I reopen my spreadsheet the lists will be gone. How do I set up my spreadsheets so the data validation lists always stay.

I have a worksheet that has 2 Colums that have 500 rows with a formula & also a Drop-Down List box. I want to be able to use these cells mainly for the formula, however sometimes a use the list in the drop down menu. I want t be able to restore the formula(s) in the cells able using them through...

I need to create an excel form for users that will filter responses based on each criteria they enter. The user interface should be the first sheet of a workbook and the data should be pulled from the second sheet. There are multiple categories with multiple options for the user to choose from...

HI Everyone I want to create a drop-down list for one Excel worksheet column (user chooses from the list for each cell in the column) using a column of data in another worksheet (primary source). I understand that you use the Data/validation function for this and I have managed to construct...

I want to create a combo/list box where I can type the first letters/digits and the list jumps to it. I have seen this on a thread before but just cannot find it, can anyone help? I am using Excel 2010 in Win 7

Warning: newbie post ahead! ;) I have a form frmClientList with a single list box to provide a quick reference whether or not a client has already been entered into the system. This is populated from a dynamic named range. Another form, frmClientJournal, logs various interactions with clients...

Since i cannot upload images ( im limited @ my work ) i try to explain as good as i can. I got a form. In this form i got 12 check boxes. If a person marks a checkbox the answer will be shown @ line "AP#-BB#" which makes the following code: If Me.chkAchmeaVitale.Value = True Then...

Hi, I am using ActiveX list box with multiple selection. Now Whenever I close the workbook and then reopen, all the previous selections are gone. Is there a way to retain selections made in listbox?

I'm fairly new to VBA and have never used option buttons before, but I'm positive what I want to accomplish is possible. I have a form with a blank listbox and 5 option buttons. When the user opens the form and selects an option I want the listbox to populate based on the option button...

I have set up a search function on a userform which searches for business names in all sheets of the attached worksheet. Ideally, when the options show up in the list box, when I double click one of them, I would like the Userform to automatically fill out with the data of the particular...

How can I handle the "No Cells Found" error when using .SpecialCells(xlCellTypeBlanks) or .SpecialCells(xlCellTypeConstants) or better yet, suggest something else to use :) Background info: I have a form, the user selects a value from a combobox. Using the selected value, a listbox beneath...

Hi, I want to know that : "Is it possible to populate a list box from one column in worksheet, as we start typing in the text box. As the letters are typed the list box should be updated with the most relevant match" If it is possible, what is the basic approch to be started. Excel vba...