Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Issue (Mixde Fields) | Excel Discussion (Misc queries) | |||
An issue when sorting in excel PivotTable | Excel Discussion (Misc queries) | |||
Excel Viewer performance issue | Excel Discussion (Misc queries) | |||
New Excel Comment Box Issue | Excel Discussion (Misc queries) | |||
Shared File & Freeze panes issue | Excel Discussion (Misc queries) |