View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?