I write code
'copy the data to the database
ws.Cells(iRow, 1).Value = Me.txtRB.Value
ws.Cells(iRow, 2).Value = Me.txtOP.Value
ws.Cells(iRow, 3).Value = Me.txtOPIS.Value
ws.Cells(iRow, 4).Value = Me.cboJM.Value
ws.Cells(iRow, 5).Value = Me.txtCJM.Value
ws.Cells(iRow, 6).Value = Me.txtUK.Value
ws.Cells(iRow, 7).Value = (txtCJM.Value * txtUK.Value)
I put values in first empty row
I don know how to make code for cell border
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
Have you tried using the macro recorder whilst adding the required border formatting.
You should then be able to adjust the recorder code to you existing code.
Post back with the recorded code if you need more help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks