When I make a comboBox selection from the dropdown menu, the menu stays down until the last statement of the comboBox code is finished. How do I make the dropdown disappear immediately after the selection is made?
View 9 RepliesI have set up a combolist box, and wish to run different VBA subroutines depending on what the user has selected from the combolist. How do I do this? Apologies in advance if this sounds like a silly question.
View 2 Replies View RelatedI 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 I blank out the range, it triggers the Private Sub ComboBox1_Change() and throws some errors because there is no data to select.
So, I was wondering if there is something I can set in my SpltData macro that will not run the ComboBox1_Change sub while the SplitData macro is running?
I am trying to develop an easier way for our corporate card holders to 'code' their monthly statements. Instead of each card holder receiving a statement and filling out a coding form in excel and printing it out, I would like to email them an excel doc of their specific charges for the month and allow them to use drop down lists to code the transactions. They can then email it back to me, and then we're done! Well, there would be a few more steps but basically, I'm trying to build a dynamic excel doc that would do two things:
1) Conditional drop down boxes so that, depending on their cost center, once they choose their cost center from the first drop down, it would zero them in on only their own account codes in the second box. The second account box would also be a combo box and show the account name once selected.
2) The second I'm not sure about.....is it possible once the conditional drop down box works, to make copies of the 'All Detail' sheet to then narrow down the info to only one card holder? So if the 'All Detail' sheet had all the charges for all the card holders for the month and the conditional drop down worked, could I then make copies of the 'All Detail' sheet, rename it to the one card holder, delete all the transactions except for those relevant to that card holder, and the conditional drop down box would still work? I ask this question because I build an early version (that didn't really work) based on a macro that had code specific to the sheet name. It wouldn't work once I tried to make copies of the sheet and rename it.
My example workbook is attached.
I have a menu with a dropdown control on it. I need it to be multicolumn (4columns, actually) but I do not know how to populate it.
View 2 Replies View RelatedI have a userform with a combobox in it that's rowsource is a column of company names in a worksheet. When a company name is chosen, a combobox change private sub runs and many userform textboxes are populated with information about the company that was chosen from the combobox dropdown. This information is stored on a worksheet. I then want to edit any of the information in these textboxes. Once my edits are made I have a CommandButton that is pressed to save the edit changes. This CommandButton runs a private sub that disables the combobox (thinking this would prevent the combobox private sub from running), deletes the row that the information originated from, and then SHOULD make a new row of values based on the contents of the textboxes following the edits. The problem is that the CommandButton coding that deletes the row causes the combobox change private sub to run because the company that had been selected is now the missing from the rowsource; this causes an error.
View 8 Replies View RelatedI wonder if it is possible in real time, to select a name from the combobox (Userform) still open Userfomr pass this value to a Dropdown in the tab?
View 3 Replies View RelatedI have a userform where I want the user to be able to select multiple options, but am having a bit of a problem finding the best way to do this. If I use a combobox, I don't appear to be able to allow multiple selections, but if I use a listbox I don't appear to be able to implement a dropdown facility. I would prefer to have a single line sized box on my form, but doing this with a listbox would probably be confusing for the user as it is not very easy to see what has been selected.
View 11 Replies View RelatedI want to make my combobox will view 2 column of list and in the textbox will view "criteria" of sellected item.
View 4 Replies View RelatedI have a set of date of different lengths that I would like in a dropdown or combobox in a grid like fashion. Example
Apple, Banana, Orange, Kiwi
Mangos, Pineapple, Passionfruit, Guava
and I am trying to get it into the dropdown/combobox as
Apple,----Banana,-----Orange,-------Kiwi
Mangos,-Pineapple,-Passionfruit,-Guava
(without the dashes, the forum does the same thing excel does)
The data is of varying lengths, and the lists are actually parts lists, so they are long and of varying lengths each. Aside from physically going in a manually padding spaces, which isn't feasible given the number of them. The have alphanumeric characters, so jumbled all together seperated by commas is very messy and hard to read. I have tried padding with spaces using a formula but they do not line up right. I have been searching for a solution either having the entries in separate cells and concatenated entries, and still no luck.
Am trying to get dynamic population of 2nd combobox based on match from criteria in combobox 1.
if column a = bears and column b = colours of bears then
when I select bears in combobox one, combobox 2 would populate with colors of bear.
I am think of having a combobox 1 change event that evaluates each row in a specific range (does it match the criteria?) if so, then add 2nd cell (column b) of that row to the combobox 2.
I know it would probably involve match and offset, add item and loop, but I am not sure what the syntax is.
I need to populate two combo boxes from excel sheet, the data will be like below:
Column A Column B
A 1
A 2
A 3
A 4
A 5
B 100
B 101
B 102
So from the above data, one combo box should hold unique values A & B.
On selecting a value from the 1st combo box A or B, respective values should be populated in 2nd combo box.
So the data should be like below:
If A is selected in the 1st combo box, then 2nd combo box should only show the values 1,2,3,4 & 5.
If B is selected in the 1st combo box, then 2nd combo box should only show the values 100,101 & 102.
Friends I need it in a macro and one important point is, this is dynamic and it is not static and the data can be more.
I have searched and have not been able to find an answer to this question so it might be a little unique possibly. I have an ActiveX combo box that I am trying to do something with. The text that I want to appear in the combo box is already there and I did this by creating a list and referencing it to the combo box. So the combo box has the following four items in its drop down:
Boat
Car
Plane
Walk
Now the part I cannot figure out is how to make a selected value appear in another cell based on what was selected in the combo box. For example, if boat is selected in the combo box, then I want the value 25 to appear in a cell. If Plane is selected in the combo box, I want the value of 100 to appear in a cell. For walk 5, and for car 22. I know this can easily be done with data validation and a validation drop down list but I do not want to use that but need to have a combo box do it instead. I just don't know if it cannot be done as a list or not and have experimented with INDEX but not having any luck there. I do not want to use any macros for this either. Basically I am wondering how I can make my combo box work just like data validation drop down menu bar with formatted values outputted into a cell.
I've done some looking around in the object browser and in the forum, but i wasn't able to find the answer to this question:
I've got a combobox (dropdown list) in a userform which i use to run macros. soft of them are fairly long (2-3seconds), and during that time the dropdown list remains visible.... is there a way to force hide it?
I am not sure if this can be done easily but essentially what I have is a userform that fills out a form that will used by several different people and saved to a central location.
There is a blank combobox currently labeled "Supplier:" that each person fills out each time on the userform (there are no dropdowns yet).
What I am wanting to do is for every person who saves (I have coded the save button) with the "Supplier:" combobox filled out to save what they entered and input that into the combobox dropdown so when the next person uses the userform the entry the previous person entered would be in the combobox as an option to select.
Essentially, a combobox populates itself based on what previous users have entered into it.
Is there any way to set the list from a Combo Box to automatically start in the middle?
Whenever I select a Combo Box, the drop down list always automatically starts at the top of my selected range, ideally I would like it to start in the middle.
For example my Range that I am filling the Combo Box with lists dates: Today()-7 to Today()+7.
At the moment the first item in the combo box list is Today()-7, I would like it to be Today().
I would like to know whether it is possible to change the background colour of items in a dropdown/combobox on my userform?
I have a series of times at 15 min intervals and i want, if possible, to distingish between 'working hours' and 'non-working hours' by making the background of these numbers 'grey'.
Maybe looping through from 00:00 to 07:00 i.e 28 times (28 x 15min intervals)?
try and achive is when a user selects a item from the 1st Combobox the 2nd Combobox is the populated with the cell that is to the right of the selected item.
for Example if a user selects AAB from combobox1,, Combobox2 should populate with Belly.
Maby using combobox1_Exit for the excercise.
I created a UserForm then linked ComboBox1 to range A2:A, TextBox2 to range E2:E, and ComboBox3 to range M2:M of the same worksheet, named Sheet3. The row contents in Column A, Column E, and Column M are associated. Therefore, when the UserForm is active I want to be able to select a row from Column A in ComboBox1 and have the UserForm pull the contents from the same row of Column E into TextBox2, and Column M into ComboBox3. Here is what I have so far, but its not quite doing it.
Code:
Private Sub UserForm_Initialize()
Sheets("Sheet3").Activate
Dim ColARange As Range
[Code].....
I have a table, headers "FirstName" and "SurName".
Further a Userform with 2 Comboboxes "FirstName" and "SurName"
I'd like to choose the FirstName (say Jack) in the "FirstName" combobox, and based on that get the choice of the Surnames of all my Jacks in the "SurName" combobox.
Actually my sheet has much more fields and comboboxes, but i think my problem is just that I do not find a way to populate them dynamically.
How can i Loop through a combobox's values and compare to a string value and then set the listindex of the combobox to that value?
View 5 Replies View RelatedI have a worksheet called "Lookup" with several dynamic named ranges (each is 1 column wide) including facility, department, shift, etc. On a summary worksheet in the same workbook I want users to use a dropdown or combo box (don't care what type) in cell B2 to select a facility and then based on their selection, copy the department named range data and paste it into the summary sheet beginning in cell A5 and paste the shift named range data into the summary sheet beginning in cell B5.
Example: user selects "AR Plant" from the dropdown or combo box and the data from the "AR_Rpt" named range is pasted into cell A5 and the "AR_Shift" named range is pasted into cell B5.
I have a list of employees that can be assigned to tasks, the list is large enough that I cannot remember who is assigned to what.
All the employees assigned major tasks are automatically filtered out but these are employees with administrative tasks that should only be assigned as a last resort. I would like to assign the employees with administrative tasks a gray, italic, strike-out or some other font to indicate that they are different.
I assume this is done during the Add Item process...
I have created a userform in which there are numerous Text and Combo boxes. In ComboBox 1 I have, in effect, a list of named ranges in a spreadsheet.
I want the RowSource for ComboBox 2 to equal the item selected (named range) in ComboBox 1.
VB:
Private Sub UserFormcriteria_Click()
Set ComboBox2.RowSource = ComboBox1.Value
End Sub
I want to fill two Combobox (cmb 2 and 3) dependent on what the user has chosen in a first ComboBox (cmb1).
The first combobox ist based on on the first sheet, and the second and third combobox shall be filled with values from other worksheet corresponding on combobox 1 selection.
I attached a xls to this post to explain better.
I have a userform with a combobox that has three items to choose from: Blue, Red, and Yellow. When a user selects one of those options, I would like another combobox to appear on my userform with a specific list for that option.
View 2 Replies View RelatedI'm trying to make a userform that has 2 combo boxes. I have just 3 columns right now.
Procedure GrpADA-QSI DescProcedure GrpAnesthesia And
Drugs9210-LOCAL ANESTH/NO SURGAnesthesia And DrugsAnesthesia And
Drugs9212-TRIGEM BLOCK ANESTHCrowns And BridgeAnesthesia And
Drugs9215-LOCAL ANESTHESIADenturesAnesthesia And
[Code] ........
I copied and pasted Column A into Column C and then removed duplicates. I named Column C 'ValList' and placed it in the RowSource for ComboBox1. What I now want is for ComboBox2 to populate based on my selection in ComboBox1. There are no duplicates in Column B. Duplicates are in Column A.
I also named Column A 'Proc_Grp' and Column B 'ADA_QSI_Desc'
For the properties in Combobox2, I left the RowSource empty. (that's correct right?) Because there's going to be a code that links Combobox2 to Combobox1... I think...
is it possible to perform calculation such as sum,multiply value of 2 combobox and get it shown at 3rd combobox/label at userform initialize stage?
I’ve found an excel sheet (witch a sample I post) from a Hobby I have, and after looking how it work’s it occur to me, that a similar file would solve I big problem in the restaurant I work. I’ve been thinking about it and I’ve now all the layout of my new-to-be file in my head, and I was going to start working on it, when I found that I couldn’t do one of the basic think on this file. Witch is to make the combobox were you can change the text according to a number or pre-determinate options. I know that you can use VBA to add combobox’s to you excel sheet, but this doesn’t seem to be the case. You can see the example in the cell B4 in the file that I post here.
View 5 Replies View RelatedTHe below have written for comboBox selection when I run thourgh form and commandButton code is not working but when run single (Seperately) code will get execute.
Private Sub CommandButton1_Click()
Dim Mydate As Date
Mydate = Date
[Code].....