combo box

Hi :) I have a spreadsheet that is used as little database, where the columns G, I, J, and M take values with data validation mode from the page "PARAMETERS". When the user tabs in those columns, a combobox appears. Users must now type the first letter and then scroll down till the right word. I...

Hi, I'm trying to use VBA to log me into a secure webpage, then navigate to a webpage where I need to select a value from a drop down box before searching the database. I cannot get the last part where it selects the value in the drop down box to work, I have used the below code. The...

Apologies in advance... i'm quite a rookie with Access. I have a table (tblCompanyInfo) with all of the information of different companys within. Within this table is a field where users can select a 'CompanyType' from a combo box. I'm looking to find a way to split the companys up into...

The code bellow goes through my list of NAEDs and if the NAED is on the list it should activate combo boxes if the NAED is not in the list it should not activate the boxes. once this code finds a partial match it makes the combo boxes available i do not want that. It has to match the NAED in...

Don't know if this has been answered in the past. But I'm trying to pass a value from a combo box into a query criteria. There is one issue though, I'm trying to get the values of yes or no into a > 0 value into the criteria value. For example, if someone chooses "yes" in the combo box it...

I have a user form with a combo box that has a mist of dates. When the user selects the date i would like the labels to change. EX: the user selects 6/18/2018 and the labels change to 6/18/2018, 6/19/2018, 6/20/2018 etc. EX: the user selects 6/25/2018 and the labels change to 6/25/2018...

Hi everybody - I previously had a drop-down box with a Data Validation list. I then created a combo box in order to have auto-complete. I have since deleted the data that was assigned to the drop-down box via the Data Validation list. I want to assign a new set of data to the drop-down box /...

Hi All you Excel Guru's I need a little help. I am using four combo boxes from the Data Ribbon (Controls - Insert - Format Controls Combo Box (From Control). I would like to set it up that when the 1st combobox changes its selection that the other three reset. Do any of you have any ideas or...

Hi ALL, I am currently using this formula =SUMIFS(INDEX('2018A'!U:AF,0,$BG$8),INDEX('2018A'!A:H,0,$BG$10),$BF$10,INDEX('2018A'!A:H,0,$BG$11),$BF$11,INDEX('2018A'!A:H,0,$BG$12),$BF$12,'2018A'!J:J,$C$7)/1000 AKA - SUMIFS((MONTH COLUMN, MONTH ID),(REGION COULMN,REGION ID),(SUB-REGION...

Hello all, I have three named ranges on my sheet. (DAYS, MONTHS, & YEARS) They provide values for my combo box userform. What I am trying to do is to have the ranges resorted to match tomorrows date automatically, and I'm not sure how best to accomplish this. For the MONTH range, since it's...

Hi all, I've been looking up how to do this online, and I haven't had much success, so hopefully someone can point me in the right direction. I am trying to create a few drop down boxes on a userform, and am trying to make the values a range from my sheet. The three drop downs will be for...

I don't know very much about coding or the Excel developer tool. :eeek: I have a spreadsheet for work that has demographic information that needs to be input. Currently, I have a combo box using data validation lists that does this for me. Here is the code I currently have in place which changes...

I have this code... when I click CommandButton1 it does what it is suppsed to do but after the command Selection.Insert Shift:=xlDown the code goes to Private Sub CMBCliente_Change() ______________________________________ Private Sub CMBCliente_Change() 'Trova riga cliente Dim Clienti As...

Hi everyone. I have three different data sets/tables that contains some common columns. The first five columns of each table have the same data type: case, period, place, process, unit. The rest of the columns have different, but correlated, data. The first table contains the feed streams of...

I have a UserForm that pulls values into a combo box from a dynamic range. On some sheets, I want to add data from the UserForm, to the last row. I can do that. I'm struggling to update the row that has the same value as what was selected in the combo box. I've looked around and I found this...

I have a list of staff and under those staff a number of tasks. I would like to add a drop down so that I may choose the task. I not sure if this is the best route or not but I thought I would throw up and ask what you guys thought the best way to do it was. Who is assigned the task changes on a...

I am trying to fill in the form of this webpage "https://login.yahoo.com/account/create?src=fpctx&intl=us&lang=en-US&done=https%3A%2F%2Fwww.yahoo.com&specId=yidReg" with the help of excel vba. Everything is working fine, except I am failing to choose option from combobox, where i need to choose...

I have created a search box which works well but after using the search box the selected text stays on the screen and will even appear on another excel file which is totally unrelated. This is what stays on the screen I will add the file to this post if i can so you can look at my code...

Hello everybody, This morning I posted a question on how to display a text depending on a value of a combo box and I had my ansyer here : https://www.mrexcel.com/forum/excel-questions/1023644-display-text-depending-value-combo-box.html But now I would like to know if it's possible to do the...

Hello everybody, I would like to create a combo box in Word and depending on the value of the combo box (A, B, or C) that the text associated with the value displays on the word. (or excel 2010 but I would prefer Word 2010 if possible) For exemple I named my combo box "Choice" and inside there...