Results 1 to 1 of 1

Thread: help required to print data in a form to a cell...

  1. #1

    help required to print data in a form to a cell...



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I am working with accounts. I will get single check for amounts which should be applying to multiple ID's (ID's means members account numbers which will be of 9 digit numerical, eg: 945727458) sl# means its serial number (1,2,3....). The dollar amount will be for single ID (eg: If I get a check of $100 and asked me to divide it between 3 accounts as they want (eg: Member ID 1. $10, Member ID 2. $ 50, Member ID 3. $ 40 like that) and I will tally these amount in page 2 in the columns by manual entry) then I will come to page one and click split button and the form will display the amounts with the ID's. Everything works fine as it is now and the form which attached provided me give the exact solution which I looked for. Now what I requested is that..I will draw the same columns in page 1 (but I will not fill in that columns manually) when the form displays that amount and I press find next, The details displayed in the form should print in the blank cells. Pls let me know if any more details required..

    I found this code in the net..I need something like this...this code is for "combobox", but here I am using "forms". The values in the form should be send to the corresponding cells when I click "find next"

    Private Sub CommandButton1_Click()
    Sheet2.Range("A1") = ComboBox1
    ComboBox1 = vbNullString
    End Sub

    Private Sub UserForm_Initialize()
    Dim i As Integer

    For i = 1 To 10
    Me.ComboBox1.AddItem i
    Next i

    End Sub

    or something like this...

    Private Sub CommandButton1_Click()
    Sheet1.Cells(1,1)=Combobox1.Text
    End Sub
    Attached Files Attached Files

Posting Permissions

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