I'm building an application that uses a large number of activex combo boxes. These boxes are getting loaded from specific fields in an associated database.
I know ActiveX combo boxes can be buggy; I'm wondering if anyone has found a way around the text appearance inconsistencies seen in these controls? e.g., sometimes the text is smaller, sometimes it's spaced wider, sometimes it appears at the top of the combo box sometimes in the center.
I put a screen shot of what I'm talking about in a word doc along with a control properties screen shot, All controls have the same properties except for the text property.
I want to populate the values of two textboxes that we will call TextBox5 and TextBox6 from columns W and X of a spreadsheet called "PowerAnalysis" when a selection is made form ComboBox5.
The ComboBox5 works perfectly now. I just need it to populate the other two text boxes.
All the data resides in the same row on the same sheet of PowerAnalysis when the selection is made in ComboBox5.
I hope I have been able to give a clear picture of what I am wanting to do.
I am developing a spreadsheet with numerous information on our different suppliers offices in the country for each of our outlets. I am tryin to define a way to do the following:
If a colleague selects a company another list will appear with the region and when the region is selected a list of the offices will appear.
I have a manualy constructed user form which has 3 data validation lists.
Sources: B7 = List 1 B12:B15 = List 2 B17:B20 and C17:C20 = List 3
These operate fine but I wish to replace the dropdown validation boxes and replace them with Combo boxes so that users are able to view the complete lists and also offer the option of inputting an item not included in the validation list if required.
I have tried many variations of input but my knowledge base is inadequate!
Mainly I end up with the combo box working on one cell only!
Can tell:
1. Do I have to raise 1 combo box per cell?
2. What vba code is necessary to make them all work?
I created a combobox on the fmEdit userform that I want to use to select a name from the worksheet and display on the Userform the data from that row for editing, which can then be submitted to make changes accordingly on that row.
I did away with the merged cells, and now I have a combo box in every cell that I want it in.
My problem is, I would like to format each combo box seperately. Every cell that has a combo box in it has data vakidation activated. I copy and pasted code to get it to work. It works great, but I would still like to change the combo box size and tab and enter functions for each individual one. I created more than one combo box but I kept getting an error on them. Any help or knowledge would be greatly appreciated.
I am posting just the code that I copy and pasted.
I am trying to use the combo box feature to navigate between sheets. In other words, I have a dropdown menu at the top of each sheet ("Main Menu," "Goals," etc.) and am trying to work out a macro that directs the user to whichever sheet is selected. Is this possible?
Is there a way to add comboboxes to a userform on the fly.
For example there are twenty different categories. I want the user to be able to say he wants 2 of these categories and 2 combo boxes pop up (each combobox has a list of the 20 categories). Then next to the categories, text boxes to type the quantity of each category.
I have quite a few combo boxes on my Excel worksheet. These combo boxes are from the Control Toolbox. Right now, the drop down lists work great, however, if the user wants, they can just type in a value. How do I stop them from doing this, and make it to where they can ONLY select one of the choices from the drop down.
I am trying to use a vlookup from input from a combobox. In other words, if a user selects "Los Angeles" from a combo-box titled "city", I want the state of California to appear in a cell labeled "State" (A3).
is there a combo boxes limitation in a certain worksheets or workbook.? if there is then how many? coz i got a problem , i have to make around 2000 combo boxes, if i save it , i got no problem , but when i closed it and then reopen , the problem occurs..
I have an excel database with comboboxes. I want to be able to filter the data, therefore I am using the autofilter function.
1) When I filter, the comboboxes above a data section that is to be viewed end up at the first row, and comboboxes below end up in the first row following the viewed data set. Is there any way in which I can hide comboboxes when their rows are hidden? Today I use the form comboboxes, but I can use the control toolbox ones if necessary. Also, I can use some other function than the autofilter function if necessary.
2) Is there any way to make the filter function take information in comboboxes into account as well? For example, if I filter by weight and one option is available in three different weightes (displayed in a combobox) I still want that to be seen following filtering (can I perhaps write information in the cell under the comboboxes? If so, can the filter function take several data in the same cell into account?).
I have in a user form 2 combo boxes. In one of my sheets I have the data that I want to be loaded in the combobox depending on the other combobox. In other words if combobox1 = white, then combobox2 needs to have the following items to be picked from "large", "medium", "small". If combobox1 = "blue" then I combobox2 needs to have another 4 items and so on. I have about 8 different options in combobox1.
What code could I use on that?
Also in that same project, I have a spreadsheet that has all my data; such as a inventory. How can I do, when I pick the SKU# to load the other fields, such as Description, qty on hand, price, etc?
How do I change the below code to fill all combo boxes all on sheets. All the names of the controls should be the same on each sheet since each sheet was created from a copy of the original.
I'm trying to create a workbook for tracking costs and change orders for multiple subcontractors. My main question is about combo boxes. I would like to create a master list of subcontractors on The masterlists tab of the attached workbook. I would like to use this masterlist as the data source for a combo box I'm going to use to replace the subcontractor txtbox on the SubCoEntryFrm. I figured getting away from a user typing something in would benefit me if I wanted to use that subcontractor name field to analyze data.
I’ve created two combo boxes and what I seem to need are “cascading combo boxes”
I have named ranges on a worksheet called LookupLists Column A has Areas and Columns H to L has services within those areas. Column headers, i.e. Row 1 of the columns, H to L are Serv1, Serv2 and so on.
Each area, in column A, has different services, in column H to L.
I have two combo boxes, what I’d like is depending on which Area is chosen in the first combo box, that the correct column is chosen which lists only those services available in that area; for example maybe Area A has services 2. Area B has services 4 …
… so in my “logical” mind if Combo box 1 I choose “Area B” then I want Combo box 2 to look at Column K and show the services from there..
I trying to do a sheet with one combo box (dropdown list) where I want the user to be able to choose "add rows" to make more boxes appear. My idea to solve this was to put all the boxes in the sheet, and then create a macro that either hides or shows the rows with the extra boxes. Now I have a problem that hiding the rows just does that, and only that. The rows disappear, but the combo boxes stay visible (but ends up on top of eachother).
I'm trying to link two combo boxes via a user form. I'm trying to select a city in one combobox which in turn would provide a listing of zip codes for that particular city in the next combobox.
I have 4 combo boxes that allow me to make selection from pivot tables. As you know in the pivot table there's the "All Selection" which does not exist in combo boxes (I think), so I created a macro to reset all the pivot tables with the "All" option selected in all of them. However the values in the combo boxes are not changing.
I have worked out (through reading and what not) how to link a combo box to a range in a worksheet. What I need to do is relate what is selected in that combo box, to another combo box which picks from another range. I have a data spreadsheet called "Offices". It's set up as follows
(Sorry, it's really frustrating trying to format it to a table type thing but you get the gist)
I have two combo boxes that both contain 7-12 separate search criteria for the user to choose from. The other includes months and the other value ranges in text form. Based on the selections, e.g. "August" from other and "increased by more than 5 %" from other, I'd like to have a command button to execute the appropriate macro. I've already compiled the macros for each occasion but I just can't figure out how to get the button to execute them. Can I use the Select Case statements? If so, how?
Oh, and whether it's relevant or not, the boxes and the button are from the control toolbar.
I am using Excel 2002 sp3 with VBA (help show VB 6.03 version 1024 on an XP sp3 machine.
I have a project with one workbook that has one form - frmRecordJob. This form has a calendar control, a combo box, 2 listboxes, some labels, and 2 text boxes. The 2 list boxes (lstCode1 and lstCode2) are in a frame. lstCode2 was created by copy/paste from lstCode1.
Checking their properties shows them to be identical except for the tab indices and top properties. Both get their row source set in the form initialization routine. These listboxes are not changed in any project code other than the form initialize event.
If I close Excel, restart Excel, open the workbook, start the VB editor, open and step through the form initialize procedure, the following occurs:
I've run into an issue where conditional formatting is working correctly 98% of the time, but 2% seems beyond logic. Basically if I have more than 120% of Stock Limit on hand I want the cells to turn green. To do this I entered the following Conditional Formatting formula in cell D4:
HTML Code: =((D4-$C4)/$C4)>=$E$1
I copied the formatting to all the other cells in the range, and most are colored correctly. This is what I get:
As you can see, it works correctly for the most part, however some cells, such as cell H5 in the example, that should be colored by they aren't.
My first thought was that this is an issue with the reference, because as I examine other cells it doesn't look like conditional formatting formulas are updated relative to that particular line, however that is the same case for my red formats and those are correct. I have over 50,000 rows so creating a new formula for each row certainly isn't the preferred option, neither is writing a macro to manually color them because of the processing time. I'm using Excel 2010.
I have created an ActiveX command button and the text on the button looks crude. I know that is not very descriptive but I am unsure how to describe it. The text looks jagged and some letters are missing chunks of their letters. The font I have chosen is Calibri.
If I create a Form Controls button I do not have this problem but I want the button to have a particular background color so I do not believe I can use a Form Controls button.
I do not know why the other Calibri text on the worksheet looks fine while the ActiveX Calibri text does not. The attached image shows the two buttons with the top one being the ActiveX button while the bottom is a Forms button.
I have searched high and low and cannot seem to find an answer. I have inserted an ActiveX button in a cell to run 3 macros when pressed. I cannot get the 4-letter name on the button to appear centered on the button, unless I make the button larger than the cell, which I do not want to do.
is there a way of changing the text direction for an ActiveX textbox? I need it to show the text in some of the boxes vertically but in other boxes horizontal.
