I ALREADY REVERSE THE CODE BUT STILL IT AIN'T WORKING..MY AMEND BUTTON WORKS AS DATABASE UPDATE AND THE INPUT/EDITED DATABASE TRANSFERED TO IT'S CORRESPONDING COLUMN..
combobox9 -> column A
combobox1 -> column B
combobox8 -> column C
textbox28 -> column D
textbox2 -> column E
textbox3 -> column F
combobox4 -> column G
textbox24 -> column H
textbox25 -> column I
textbox26 -> column J
textbox5 -> column K
combobox7 -> column L
PLEASE HELP ME...
Please Login or Register to view this content.
.Cells(.Rows.Count, 0)
There's no such thing as column 0. Column A = 1, B = 2, ...
You can also write .Cells(.Rows.Count, "A"). ...
Ben Van Johnson
but why does if i edited some data on the user form
it ddin't copy to worksheet?
You have this line: On Error GoTo exitsub
Therefore, when the code gets to the line .Cells(.Rows.Count, 0), the procedure branches directly to the exit point because that line errors out.
Write: ... .Cells(.Rows.Count, "A"). ...
Also, you have:
Please Login or Register to view this content.
Last edited by protonLeah; 05-10-2013 at 12:35 AM.
wow... wow.. wow.. please attach your fixed Ambor file.. I need itI use similar stuff.. and found on forum similar file but this is great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks