Re: Combo Box Problems

Tech-Archive recommends: Fix windows errors by optimizing your registry

How would I go about doing your first option scrolling acroos the row and
stopping at a match?

"tsides@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" wrote:

On Aug 13, 10:00 am, daphoenix <daphoe...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
I would like to make a combo box in my work*** do exactly what the Name Box
does. When a item in the combo box is selected scroll right or left through
the work*** and find that heading that was selected in the combo
box?.....Is there a way to do this? Thanks.

Use the Name Box itself, then? Create Named Ranges with the same name
as the headings.

Otherwise, you can write macro code which scrolls across the row,
comparing the combo box value to the value in the cell, stopping at a
match. Is the combo box in a Form, or is it in a cell as a Data
Validation? That'll determine whether you write the code as a
callback to the combobox.change event or as triggered by the change in
the value of a cell on the work***.

.

Quantcast