combo box event

I have add Combobox to page. Dim Combo As ComboBox Set Combo = ActiveSheet.OLEObjects.Add(ClassType:="Forms.ComboBox.1", Link:=False, DisplayAsIcon:=False, Left:=50, Top:=80, Width:=100, Height:=15).Object And I need to add TextChanging events to this Combobox, but how to do this?

Hello ! I am trying to fill a multi-column ListBox based on a selection on a ComboBox (being populated through RowSource property). I am having an issue because the code works but is only showing the first row of data found and not all of them. I believe its because its not in a loop, but not...

Hi Experts, I am using one of the sheet of Excel as DB (Sheet Name - Database) and another sheet as User Interface (Sheet Name - UI). The User as flexibility to search the data based on filter selection. There are 5 Combo Box filters. Everything is working fine. Apart from one unusual problem...

Hi, I have a UserForm with some combo boxes, text boxes and radio buttons. I need to change the location of the data in the textboxes based on the selection from ComboBox1. On the change of ComboBox1 I need to index a column to next. Value of A7 = column BD, Value of A8 = BE etc... Not sure how...

Hi all, Need some help on this one. I am doing some work for a retailer that uses a Department, Class and Category hierarchy for their products. I populate the 1st combobox (cboDept) with a list of departments. Based on the selection made in this combobox, the 2nd combo box (cboClass) needs to...

Hi, I'm quite new to VBA, but I am attempting to get a Forms ComboBox to appear or disappear based on whether a certain cell (P7) reads YES or NO. P7 in turn updates in turn based on a user-selected value. As of now, the ComboBox only appears or disppears if I go back in and out of the formula I...

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

Hi, I have an issue with a combo box and radio button. Anytime I click on either of them, they reduce in size. It's as if it is reducing by the same ratio every time until you can't click on it anymore. Has anyone ever seen this happening before? I'd post a picture, but I'm don't have...

I have a UserForm I am working on where the user is to make a selection from a dropdown style combo box. The problem I am having is I only want the user to be able to make a selection from the dropdown and not input there own value. I have set the property: Match Required to True. Right now...

Hey guys and girls, I've learned lots from Mr Excel thus far, so thank you! I'm doing great building a VBA form to record in a worksheet, but I just hit a wall, so could really use some help! OK..here goes. I have a combobox and answers can only be Yes or No. If the answer is No, I need a new...

Hello all, I have created a matrix to help me priorities data collection of different datasets for a project I am working on. I have the same datasets listed horizontally and vertically so I have the same number of rows and columns. Within each cell the user the selects one of the two...

Hi All, I've searched here and googled but to no avail. I'm not to savvy on this VBA stuff but have fumbled around and created a Userform with a ComboBox and several other fields in an Excel Workbook. The ComboBox gets its list of Customer names from a range in a worskeet...

Okay, Access 2003, XP First, I have a simple 2 column table named "Products". Column 1, "Product_Name", has, you guessed it....a list of Product Names. Column 2, "Employee" has the Employees name that handles that product. Okay, so, on my form I have 2 Combo Boxes. Box 1 "Product Combo"...

Hi all, I am trying to populate an ActiveX ComboBox on an Excel spreadsheet with file names from a given directory. Currently I have a "refresh" button that users can click to refresh the drop-downs when they add new files to the folder. I would like to automatically do this. I have tried...