speedracer
12-25-2006, 04:42 AM
I am using a combo box in a worksheet(A), and using vba code associated with the combobox object to write a value to a cell on another worksheet(B)(...in the same workbook). However, that cell then becomes locked somehow, and cannot be edited manually. Why is this, and how can I correct it.
I am creating a solution to be able to schedule employees and keep track of the number of times in a 90 day period that they are working in a certain area, in an effort to be able to provide fair distribution of these areas between employees. A combo box for each area provides a list of employees, populated from another worksheet. To avoid scheduling the same employee in two different areas, I decided to write an "x" to the adjacent cell to the employee name so that the user would see that that employee has already been selected for another area. Then all of the combo boxes are populated, and the user can look for the employee name without an "x" next to them.
The problem is that at some point, the user will need to manually delete that x in the other worksheet to correct an error. This cannot be done to the value that is written to the cell by the macro. It seems to be locked in some way. I try to delete the value written to the cell by the macro, and am unable to edit the cell at all. Even when deselecting the associated combobox, the cell is still locked.
I have never run accross this before. I am perplexed on why this is happening, and how to correct it.
Thanks for anyones help.
SRM:banghead:
I am creating a solution to be able to schedule employees and keep track of the number of times in a 90 day period that they are working in a certain area, in an effort to be able to provide fair distribution of these areas between employees. A combo box for each area provides a list of employees, populated from another worksheet. To avoid scheduling the same employee in two different areas, I decided to write an "x" to the adjacent cell to the employee name so that the user would see that that employee has already been selected for another area. Then all of the combo boxes are populated, and the user can look for the employee name without an "x" next to them.
The problem is that at some point, the user will need to manually delete that x in the other worksheet to correct an error. This cannot be done to the value that is written to the cell by the macro. It seems to be locked in some way. I try to delete the value written to the cell by the macro, and am unable to edit the cell at all. Even when deselecting the associated combobox, the cell is still locked.
I have never run accross this before. I am perplexed on why this is happening, and how to correct it.
Thanks for anyones help.
SRM:banghead: