- Joined
- Aug 19, 2016
- Messages
- 29
- Reaction score
- 1
Dear all
I have created list and inserted combobox from actvex in b6. Right clicking at the box, I selected properties. In the relevant place I entered the range where values are stored (o1.o42) and also entered the drop down lines as 42. Then I clicked design menu to come out.
Now in b6 , combo box arrow appears and clicking on it I get the list to select. Till this point, no problem. But when I tried to enter data in b7
with a combo box, there is no combo box appearing. I want the combo box appears in all the rows down b6.
I do not where I went wrong
Now I am using data validation dropdown.
Please help me as to how I can create a combo box.
M S Narayanan
I have created list and inserted combobox from actvex in b6. Right clicking at the box, I selected properties. In the relevant place I entered the range where values are stored (o1.o42) and also entered the drop down lines as 42. Then I clicked design menu to come out.
Now in b6 , combo box arrow appears and clicking on it I get the list to select. Till this point, no problem. But when I tried to enter data in b7
with a combo box, there is no combo box appearing. I want the combo box appears in all the rows down b6.
I do not where I went wrong
Now I am using data validation dropdown.
Please help me as to how I can create a combo box.
M S Narayanan