Hi,
In my excel i have used around 10 Activ-X Combo Boxs, it used to work well when the operations on this Combo Boxes are preformed using mouse, based on the selections in the Combo Box, i used to populate the data in other cells, clear the data and set colors to the cells. Every thing was working well, the problem started when the user used tab keys to move on to the Cells.
If a tab key is used to move on to the Active-x Combo and he selects some item in the combo, and when he moves to other cells and enters the data it was ok, but when he selects other combo box Excel is crashing.
Please let me know if i need to do any seeting with respect to Use of tab keys on Acitve-X Contorls.
My observations: When i removed the LinkedCell value of the ComboBox, then there was no crash seen. But if the user types the data, entered value will be behind the cell which wil not be displayed. I am interested to know if the tab key usage should need any other settings.
Another test which i performed now is - i unlined the cell from the comboBox when the user tabs to the comboBox cell and types the data, the data typed will be behind the comboBox, i am writing this data to the comboBox after cell change, in this case its working well, i can use this approach but i have 10 Active-X controls in the Excel, i need to do the same for all the things, i am looking if there is any simple approach to resolve this issue, i want to know if i have done any thing wrong in my configuration, please guide me
Any of your suggestions will be helpful.
Bookmarks