Get frame name in userform to input a certain cell

[Nguyen Tien Long]

Dear FFL,

I am creating an Userform to import data into a Sheet, and I want to know how to:

- Import Frame Caption into a cell when some controls (text box, check box) in Frame change

For example (File attached): When i fill some info in (one) textboxes "So hieu bieu gia" in Frame "Kiem tra bieu gia", then "Kiem tra bieu gia" auto fill in cells of B column;

- When value of textboxes and check boxes are imported in column C and E respectively, Name in combo box and Caption of Frame must be auto filled until meet the last value of those cells.

For example: When I choose name LongNT and fill 2 textboxes in Frame "Kiem tra bieu gia", their values auto imported into cell C2, C3, then:

- A1, A2 must be filled with "LongNT"
- B1, B2 must be filled with Frame Caption, in this case is "Kiem tra bieu gia"

Plz help me write code for those problems.