+ Reply to Thread
Results 1 to 1 of 1

Get frame name in userform to input a certain cell

  1. #1
    Registered User
    Join Date
    05-04-2012
    Location
    Ha Noi, Viet Nam
    MS-Off Ver
    Excel 2010
    Posts
    5

    Get frame name in userform to input a certain cell

    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.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1