Multipage form - Help

[Shetty]

I have created a multipage form for data entry in a sheet.
tab1 has a constant entry fields i.e. six textboxes whereas
tab2 has one combobox, one textbox for data entry and two textbox
to show the value corrosponding to combobox value.
Problem :
1) How to read the combobox value selected?
2) How to populate the two textboxes w.r.t. combobox value based on vlookup?
3) Most imp: For each set of constants in tab1, there will be multiple entries
in tab2. Say once all the data entry is done in both tabs, user clicks
on add item, six entry on tab1 and two on tab2 will be written on one
row in a sheet "basic". Now keeping the tab1 boxes same, tab2 boxes
should be cleared for next set. For these next set also tab1 will be same.
Tab1 and tab2 boxes to be cleared when user clicks on finish button.

Request some help please.
Regards,
Shetty

 

[Smalltalk_vb]

1. ComboBox1.Text, should give you the value of the combo
2. varTemp = Range("address of the formula that contains
the vlookup")
3. controls on a tab will have unique names, so you can
reference the control name is code

tab 1
txtFirstName.text
txtLastName.text

tab 2
cbState.text
cbCity.text

assign values to sheet, Basic
basic![a1]=txtFirstname
basic![a2]=txtLastName
basic![a3]=cbState.text
basic![a4]=cbCity.text

cbState=null
cbCity=null

 

[Shetty]

Thanks for your reply.

I was trying, matcode = cblist.value and tbmat.value which was giving
error.
where cblist is combobox and tbmat is textbox.
I will try your suggetion.

2. varTemp = Range("address of the formula that contains
the vlookup")

I could not understand this. Did you mean that I have to put up the
vlookup range? Then how it will retrive the data sought for?
Since vlookup contains 4 arguments, putting it inside the range will
create the error. This is what I understand, please correct me where I
am mistaking.

Regards,
Shetty.