Hello all,

can anyone help?

i have a combobox, when i select a value from it i need it
to update 6 textboxes.

the values for the combobox are located in column "AX" and
the values i would like to input into the textboxes are
located in the relevant rows but column "AY".

e.g.

select value "26/04/2004" from combobox ==

where "AX" = combobox, i would like the first textbox to =
first value from "AY" ==

then.. continue through "AX" to find next cell that meets
combobox value, then the next textbox to = the cell.offset
(0,1)==<END

is there any way of doing this?

also would like it to happen on click!

sorry!

thank you,

Robert Couchman