ah yes thanks... i forgot to add "box" in it.... the userform is working fine just now....
a few more help pls....
1. Why everytime i save the data, it added to row 25 instead of below A3 as i declared in here...
RowCount = Worksheets("EXPENSES").Range("A3").CurrentRegion.Rows.Count
With Worksheets("EXPENSES").Range("A3")
.Offset(RowCount, 0).Value = UserFormKas.CBOJenis.Value
.Offset(RowCount, 1).Value = UserFormKas.CBOTipe.Value
.Offset(RowCount, 2).Value = UserFormKas.TXTBOXDesk.Value
.Offset(RowCount, 3).Value = UserFormKas.CBOBulan.Value
.Offset(RowCount, 4).Value = UserFormKas.TXTBOXJumlah.Value
End With
what am i supposed to add to the Code?
2. How can i make the userform to add the "Jumlah" entry data to the respective month column that selected from "Bulan" Combo box in the EXPENSES sheet? Is there a way to make it happen? because ive read a few guide about it and still i couldnt find a thing...
thanks for the help,,, I am sorry for my bad english,, just ask me if you dont get my words
Bookmarks