I have a combo box. I want to bring back the content of the cell which is combo box is linked to.
I don't need to get the numbers that combo box gives me, but I need the text which is in drop down menu of the combo box. Does indirect function works for this purpose?
I am confused ; can you clarify whether you want to do it within your worksheet , or from within your VBA Project ?
If it is within your worksheet , doesn't your linked cell already give the contents of your combobox ? What is the text in your combobox , and what does your linked cell display ?
It is in a worksheet. I have made a drop down menu and SumIFs and CountIFs function, It picks up the value from those drop down menus and a database. It works well. But I want to have a combo box instead of drop down menu. The reason is that the combo box shows the arrow but when I make a drop down menu with data validation, it is not showing the arrow until I hover the mouse over the drop down menu.
I have inserted a combo box and I link the combo box to a list. The list is shown in combo box and when I select each value from combo box, it gives back a number and I can't use that number in the countIfs or sumifs function. I need the combo box gives the text that I have inside the combo box.
There should be a trick here that allows me to use the combo box and text inside that. I can make a dummy data and email it to you if you have any email. That is great help.
