Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to overcome this System Error &H80004005 (-2147467259)? | Excel Discussion (Misc queries) | |||
Overcome LOOKUP limits and NOW() | Excel Worksheet Functions | |||
How to overcome LOOKUP function problems? | Excel Worksheet Functions | |||
Pivot Table - Overcome col. limit? | Excel Programming |