hello
if the range always variable how can I make a listbox
source.
here is sample what a have.a,b,c is column 1,2,3,4,5,row
a b c
1 a1 sour bla bla
2 a2 sweet mala mala
3 a2 spicy pala pala
4 a1 sweet bla bla
5 a3 sour mala la
objects textbox1,textbox2,listbox1,commandbutton1. I want
to key in on textbox1 example"a1" is that possible for
listbox to show sour(b1),sweet(b4) and when click on b1 on
listbox textbox2 to show "bla Bla"(c1).so far i can only
make find each text1 object in the sheet and offset(0,3)
am I in wrong way?Thanks in advance have a good day.