DV Issue
 

Hi,
We are using Excel2000.
We have a data validation (DV) list in
col A and we have a macro running a
combo box which allows us to zoom in to the nearest
selections by typing the 1st letter.
When we double clik to start the DV list, there will be a grey area cover
the cell. In turns of function, it still working fine. Just want to get rid
of the grey cover. By the way, we freeze the col ant row at B3. Any solution.

If you're using the combobox code from my web site, in the code, remove
the height adjustment:

instead of:

.Height = Target.Height + 5

use:

.Height = Target.Height


Pong wrote:
Hi,
We are using Excel2000.
We have a data validation (DV) list in
col A and we have a macro running a
combo box which allows us to zoom in to the nearest
selections by typing the 1st letter.
When we double clik to start the DV list, there will be a grey area cover
the cell. In turns of function, it still working fine. Just want to get rid
of the grey cover. By the way, we freeze the col ant row at B3. Any solution.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html