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
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