Excel 2007 : Combobox

**Udhay** · 09-27-2010, 11:00 PM

I get a problem with the combo box.

If I want to feed different input value I need to select case NO first. I am unable to select the Case YES consecutively for giving different input value. I want to use only combobox.

Also help me to retain the previously entered value if the user clicks "cancel" while inputting in input box (For case yes).

Here is the VB excel program i wrote.

Please Login or Register  to view this content.

**royUK** · 09-28-2010, 01:32 AM

Is this wht you mean?

Please Login or Register  to view this content.

**Udhay** · 09-28-2010, 01:40 AM

Originally Posted by royUK

Is this wht you mean?

Please Login or Register  to view this content.

Thanks Ron!
that helped me. What can i do for the first part of my question? I am confused about the loading procedure of options into combobox. I want to click the case "yes" consecutively the second time and enter different value for it. But that doesn't happen. I need to switch to case 'no' and then to case 'yes' again. Pl help. Thanks.

**royUK** · 09-28-2010, 02:14 AM

Please don't quote replies.

Not sure what you mean.

Currently if you enter a different value it will over write the previous entry anyway

**Udhay** · 09-28-2010, 02:43 AM

My program does not let me choose the same case "Yes (Shaft offset with main shaft)" second time consecutively. Once I have chosen the option yes and input the value, If i need to reenter the input i need to select the other case "No (shafts are coaxial)" and then I need to select the option"Yes (Shaft offset with main shaft)" again. can you help me fixing this?

One more problem is everytime I open I need to run VB to load the ComboBox list with the cases. Is there any option to load it itself when excel is opened?