Shaveta
New Member
Hello there!
Thanks for reading this.
I am using activex comboboxes for the first time in my worksheet and I am facing a couple of issues with the same. I have attached screen shots to better explain the issue.
1. I am using two combo boxes both having searchable dynamic lists. When I type anything in combo box 1, the list matching the text that I input appears in the drop down as below:
However, once I have selected an item in combo box 1, ideally it should remain passive until it's left idle. However, in my sheet when I try to fill anything in combo box 2, the drop down list in combo box 1 gets active and to extract drop down list in combo box 2 I have to first click on combo box 1. Then only I am able to get the drop down list for combo box 2 and that too only if I press the down arrow.
This issue is not limited to the combo box selection. Even if I press the buttons or switch the tab or do anything really, the drop down list (with only one item in drop down) keeps on occurring. I have no clue how to resolve this issue so that the sheet can become user friendly. I am using following code in the "view code" page of this sheet
2. I am using a button on the press of which all the data input in this sheet is posted to another worksheet to sort of make a report of all the entries. While going through step by step execution of my macro associated with the button, I noticed that the private sub Combo Box_change event of the two combo boxes gets triggered repeatedly (even when the input field has nothing to do with the combo box) which results in some delay in the execution of macro. Is it normal with active x combo box?
3. Also, is there any way that I could jump from one input cell/ object to another (from top to bottom) using tab or some such key?
I would really appreciate if I could get some help on these.
Thanks
Shaveta
Thanks for reading this.
I am using activex comboboxes for the first time in my worksheet and I am facing a couple of issues with the same. I have attached screen shots to better explain the issue.
1. I am using two combo boxes both having searchable dynamic lists. When I type anything in combo box 1, the list matching the text that I input appears in the drop down as below:
However, once I have selected an item in combo box 1, ideally it should remain passive until it's left idle. However, in my sheet when I try to fill anything in combo box 2, the drop down list in combo box 1 gets active and to extract drop down list in combo box 2 I have to first click on combo box 1. Then only I am able to get the drop down list for combo box 2 and that too only if I press the down arrow.
This issue is not limited to the combo box selection. Even if I press the buttons or switch the tab or do anything really, the drop down list (with only one item in drop down) keeps on occurring. I have no clue how to resolve this issue so that the sheet can become user friendly. I am using following code in the "view code" page of this sheet
Code:
Private Sub ComboBox1_change()
Dim sht1 As Worksheet
Set sht1 = Worksheets("Entry Post")
If ThisWorkbook.ActiveSheet.Name = sht1.Name Then
ComboBox1.ListFillRange = "DynamicList1"
Me.ComboBox1.DropDown
Else
Exit Sub
End If
End Sub
Private Sub ComboBox2_change()
Dim sht1 As Worksheet
Set sht1 = Worksheets("Entry Post")
If ThisWorkbook.ActiveSheet.Name = sht1.Name Then
ComboBox2.ListFillRange = "DynamicList2"
Me.ComboBox2.DropDown
Else
Exit Sub
End If
End Sub
2. I am using a button on the press of which all the data input in this sheet is posted to another worksheet to sort of make a report of all the entries. While going through step by step execution of my macro associated with the button, I noticed that the private sub Combo Box_change event of the two combo boxes gets triggered repeatedly (even when the input field has nothing to do with the combo box) which results in some delay in the execution of macro. Is it normal with active x combo box?
3. Also, is there any way that I could jump from one input cell/ object to another (from top to bottom) using tab or some such key?
I would really appreciate if I could get some help on these.
Thanks
Shaveta
Last edited: