Hello. I have a little problem with VBA (in Excel 2003)

I WANDERED what is the code to lock down a combo box on a combo box in excel. All I want to do is lock is so that people cannot alter the text already in the combo box, but still be able to use it. I have tried combobox1.lock but so far no luck...and I cannot find anything in the properties that will do this. (bear in mind it is taken from the control toolbox not the form toolbox).

Any help would be appreciated, thanks.

BUMP

Can you help please?I was unable to find whether the .locked property had been dropped for Excel 2003 combo boxes. If you can't find it on the property SHEET, you may be able to define a range object for the cells the combo box covers. The range object should have a .locked property.

Double check that there are no overlaps or INTERSECTS with other controls you may have defined.

Good luck. There is a .locked because when ENTER "." it gives me an option of possible choice. And
the combo box is not covering any cells it is over the spreadsheet, as they are the same as VB controls...Quote

All I want to do is lock is so that people cannot alter the text already in the combo box, but still be able to use it.