combobox change event

Hi, I come with a question involving excel VBA since I am no longer sure how I should proceed with this on Excel 2010. Right now I have : 1. a summary table that is summed from 2 different single cell columns 2. they come from different month worksheet (12 in total) 3. currently, there are...

Hi, I have a large macro called SplitData, which takes a load of data and splits it and reformats it each month. I have 4 Activex Control combo boxes on one sheet that are linked to a range...this range changes each month, so I blank out the range and then repopulate. My problem is that when...

Good Evening, I have two comboboxes that I am trying to populate from an excel sheet and I could use some help getting the second one to work. The first box is a "Make" box where the user selects the make of, say - a car. From there, it populates the second "Model" box based on the models...

I've been putting together a macro that reads in cells from one specific row on <CODE>Sheet1</CODE> and places them onto a ComboBox on a <CODE>Sheet2</CODE> <CODE>|cellA | cellB | cellC | cellD | ... |cellZ | </CODE> </PRE>Once loaded to the ComboBox, whatever cell is selected there has it's...

Hi, First poster so please be kind. I will provide as much info as possible. I have a User Form in Excel 2003. On the form is a combo box called "cbclient" which draws its values from Column A of a worksheet called "ClientList". When a selection is made from this combo box, I would like two...

This thread is spawned from another where I am trying to work through some comboBox problems. It has been suggested that the Change event is the 'default' event or a comboBox or maybe the event of choice. I'm not real clear on what this means but it seems like there are problems concentrating on...

Hello, I am working with a piece of code found here: http://www.mrexcel.com/forum/excel-questions/249841-hide-unhide-rows-selecting-letter-combobox.html. My version of the code is aimed at hiding certain columns based on a the selection in the combobox. The combobox object was initially added...

I am using excel 2007 and i want to change the background colour of a combBox(Active control) depending on what is selected. So I have a simple Yes/No selection that is blank to start off with. When it is blank i want the colour to be default, but when you choose Yes i want the backgroung to...

Help! I have gotten to a point of partial success (much to the thanks of subscribers to this forum!) but am now stumped. I need to have a single combobox pull values from a very large term list (>40,000), and place selections in a single column in sequential cells (eg, B1, B2, B3, etc..). With...

I have a workbook with some ActiveX comboboxes. When I have it open and open any other workbook I get "Run-time error '9'. Subscript out of range." When I debug it opens the change event for the combobox. I can't figure out what I have wrong that causes this error to come up when opening any...

Hi Folks, I have a combo box that is 1st in the tab order Control Source c15, the second combo box RowSource is set to Indirect(c15). I have to close the form before c15 is updated with the new value before my indirect function works. Is there something I can do to stay in the form view...

Hi i have 3 comboboxes and want the last to to read a different Worksheet dependent on what the input is in the first combobox is this possible and if so how is it done ?? the code i have so far is: Private Sub UserForm_Initialize() Dim Site As Range Dim Location As Range Dim Printer_Type As...

Hi, I'm new to VBA. This is my senerio. Few items are added to the ComboBox when the form is initialized. I am copying data from excel to textboxes, comboxes, optionbuttons etc. Based on a cell value (which is a string), the ComboBox text is loaded using 'ListIndex'. I need to populate few...

I am trying to populate a combobox (CboMilestones) based on the project number that appears in CboProjNum. I need the values of certain columns to be added to CboMilestones. My spreadsheet is laid out in a paticular order based on a SQL upload that I will have to perform (1st column = project...

Hi, I have a combobox that has in its list numbers from 1 to 20. Whenever a user changes the number, some macro runs. The problem that I am facing is that if lets say 2 was chosen before..so "2" will be displayed in the combobox. now when i want to run that macro again with "2" as an option, it...

Hello All, I'm new to the forum and haven't had a lot of time to scour the contents, so if this question has been answered before, I apologize. Background: I'm working a creating a spreadsheet as a classification system for certain documents. I realize Excel is not the most elegant solution...

Hello All, I'm new to the forum and haven't had a lot of time to scour the contents, so if this question has been answered before, I apologize. Background: I'm working a creating a spreadsheet as a classification system for certain documents. I realize Excel is not the most elegant solution...

All, I have a dynamic range serving as a RowSource for a list that populates a ComboBox in a userform. I only want the user to see the non-blank items in that range. I am also using the selection to run a application.match off of so I need to retain it to pre-populate some textboxes. How can...

Hello, I would like : - to force users to select a value of a Combobox (my values are in ListFillRanges yet) (if they don't do it, it must be error). - to prevent users from entering, in a combox, other values than the indicated. Any way of doing it ?

Hi, I am struggling with a combobox on a userform. I need 2 cascading comboboxes and a textbox. Obviously the data in combobox 2 is dependent upon the choice made in combobox 1. Then the user can type anything in the textbox. But, depending on the choice made in combobox2 - the text/value in...