how do I overcome this combobox 'bug'?
 

I have a combobox in a userform1. in __Private Sub UserForm_Initialize()__, I
defined the field and row for the Control Source and Row Source. The contents
of the row source, for instance are the following: bed, ted, med, jed. RUN
USERFORM, select any one of the four words in the combobox and tab to the
next control on the form. Now go back to the combobox that has one of the
four words and highlight only the first letter of the word and change it to
any of the other first letters of the remaining words and tab to the next
control. When I look at the control source that I have set up on a worksheet,
I see that the value of the combobox did not change. If I highlight the whole
word and reenter one of the remaining words then the control source will
change. If I highlight two letters, the control source will change. But for
some reason, if I only highlight and change the first letter of the word in
the combobox, the control source will not change. I have changed several of
the properties of the combobox and have tried several of the event handlers
but nothing seems to help. Is this a built-in bug or is there a solution to
this problem?

how do I overcome this combobox 'bug'?
 

Worked for me as expected. I tried it with Calculation set to Manual and
Automatic. But I could not replicate your issue I'm afraid.

"Paul D." wrote:

I have a combobox in a userform1. in __Private Sub UserForm_Initialize()__, I
defined the field and row for the Control Source and Row Source. The contents
of the row source, for instance are the following: bed, ted, med, jed. RUN
USERFORM, select any one of the four words in the combobox and tab to the
next control on the form. Now go back to the combobox that has one of the
four words and highlight only the first letter of the word and change it to
any of the other first letters of the remaining words and tab to the next
control. When I look at the control source that I have set up on a worksheet,
I see that the value of the combobox did not change. If I highlight the whole
word and reenter one of the remaining words then the control source will
change. If I highlight two letters, the control source will change. But for
some reason, if I only highlight and change the first letter of the word in
the combobox, the control source will not change. I have changed several of
the properties of the combobox and have tried several of the event handlers
but nothing seems to help. Is this a built-in bug or is there a solution to
this problem?

how do I overcome this combobox 'bug'?
 

I'm on Excel 2002 & SP3

"Patrick Molloy" wrote:

Worked for me as expected. I tried it with Calculation set to Manual and
Automatic. But I could not replicate your issue I'm afraid.

"Paul D." wrote:

I have a combobox in a userform1. in __Private Sub UserForm_Initialize()__, I
defined the field and row for the Control Source and Row Source. The contents
of the row source, for instance are the following: bed, ted, med, jed. RUN
USERFORM, select any one of the four words in the combobox and tab to the
next control on the form. Now go back to the combobox that has one of the
four words and highlight only the first letter of the word and change it to
any of the other first letters of the remaining words and tab to the next
control. When I look at the control source that I have set up on a worksheet,
I see that the value of the combobox did not change. If I highlight the whole
word and reenter one of the remaining words then the control source will
change. If I highlight two letters, the control source will change. But for
some reason, if I only highlight and change the first letter of the word in
the combobox, the control source will not change. I have changed several of
the properties of the combobox and have tried several of the event handlers
but nothing seems to help. Is this a built-in bug or is there a solution to
this problem?

how do I overcome this combobox 'bug'?
 

I'm using Excel XP. I made a new userform in a new workbook and replicated
this error everytime. Could it be a problem in XP?

"Patrick Molloy" wrote:

I'm on Excel 2002 & SP3

"Patrick Molloy" wrote:

Worked for me as expected. I tried it with Calculation set to Manual and
Automatic. But I could not replicate your issue I'm afraid.

"Paul D." wrote:

I have a combobox in a userform1. in __Private Sub UserForm_Initialize()__, I
defined the field and row for the Control Source and Row Source. The contents
of the row source, for instance are the following: bed, ted, med, jed. RUN
USERFORM, select any one of the four words in the combobox and tab to the
next control on the form. Now go back to the combobox that has one of the
four words and highlight only the first letter of the word and change it to
any of the other first letters of the remaining words and tab to the next
control. When I look at the control source that I have set up on a worksheet,
I see that the value of the combobox did not change. If I highlight the whole
word and reenter one of the remaining words then the control source will
change. If I highlight two letters, the control source will change. But for
some reason, if I only highlight and change the first letter of the word in
the combobox, the control source will not change. I have changed several of
the properties of the combobox and have tried several of the event handlers
but nothing seems to help. Is this a built-in bug or is there a solution to
this problem?

how do I overcome this combobox 'bug'?
 

Excel 2002 is Excel XP

--
Regards,
Tom Ogilvy


"Paul D." wrote in message
...
I'm using Excel XP. I made a new userform in a new workbook and replicated
this error everytime. Could it be a problem in XP?

"Patrick Molloy" wrote:

I'm on Excel 2002 & SP3

"Patrick Molloy" wrote:

Worked for me as expected. I tried it with Calculation set to Manual
and
Automatic. But I could not replicate your issue I'm afraid.

"Paul D." wrote:

I have a combobox in a userform1. in __Private Sub
UserForm_Initialize()__, I
defined the field and row for the Control Source and Row Source. The
contents
of the row source, for instance are the following: bed, ted, med,
jed. RUN
USERFORM, select any one of the four words in the combobox and tab
to the
next control on the form. Now go back to the combobox that has one
of the
four words and highlight only the first letter of the word and
change it to
any of the other first letters of the remaining words and tab to the
next
control. When I look at the control source that I have set up on a
worksheet,
I see that the value of the combobox did not change. If I highlight
the whole
word and reenter one of the remaining words then the control source
will
change. If I highlight two letters, the control source will change.
But for
some reason, if I only highlight and change the first letter of the
word in
the combobox, the control source will not change. I have changed
several of
the properties of the combobox and have tried several of the event
handlers
but nothing seems to help. Is this a built-in bug or is there a
solution to
this problem?