Hi all,

Is it possible to use a UserForm to preview data?

I have the folowing in a sheet

Account Branch RecNo Amount

abcd a 1 10
def b 2 15
abcd b 3 25
defg a 4 20

If I create a UserForm with a combobox for RecNo and
three TextBoxes for corresponding data, How can i code to
get the data on TextBox ?

TIA
Soniya

Soniya..


create a defined name for the range e.g. "formSource"


set following properties of the combobox

..rowsource "formSource" (text)
..columncount 4
..columnwidths 0 pt;0 pt;;0 pt
..matchentry 0 matchentryfirst
,matchrequired true
..style 2 fmstylelist

then add following event in the code module of the form
With ComboBox1
TextBox1 = .List(.ListIndex, 0)
TextBox2 = .List(.ListIndex, 1)
TextBox3 = .List(.ListIndex, 3)
End With

suc6

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Soniya" wrote:

Hi all,

Is it possible to use a UserForm to preview data?

I have the folowing in a sheet

Account Branch RecNo Amount

abcd a 1 10
def b 2 15
abcd b 3 25
defg a 4 20

If I create a UserForm with a combobox for RecNo and
three TextBoxes for corresponding data, How can i code to
get the data on TextBox ?

TIA
Soniya