LinkBack URL
About LinkBacks
hi
i have a userform with update button to update cells in worksheet. it updates only 1st 3 cells of the row and does not update the rest. can you review the code for any mistake. thanks
I am attaching the worksheet
test.xlsm
hi
i have a userform with update button to update cells in worksheet. it updates only 1st 3 cells of the row and does not update the rest. can you review the code for any mistake. thanks
I am attaching the worksheet
test.xlsm
I ran the form, inputted data, and it updated the entire row.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
hi
thanks for quick response
there are 2 buttons, add botton works fine, update button is activated once the entry is seleclted from list box. please verify update when view data option is selected. thanks
The row source of the listbox is linked to the firstname and lastname. Those are the only 2 fields which are not getting updated. If you comment (') those lines, you will see that the code works.
As soon as the code reaches the first name, it calls the listbox change code and thus you do not see the rest of the updates.
Thank You Arlette, that was amazing. cheers, Jas
Did you solve it? What changes did you do?
Hi
Not fully solved, i put comments(') before firstname and lastname textbox code, and disabled these textboxes when update button is active. So firstname,lastname would remain non updatable. If you have any suggestion, would appreciate. Thanks
I think this should update the fields:
Please Login or Register to view this content.
Last edited by stojko89; 09-20-2012 at 04:51 AM. Reason: Code Edit
add to top of form
then change codes for update button and listbox_change toPlease Login or Register to view this content.
not sure if it was deliberate that you have no code to alter the address field?Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Hi,
I apologize for being late to reply to the responses. Thanks Stojkos89 and JosephP.
I have tried the code by JosephP and it has worked perfect. The other code by Stojko89 is little confusing to me. I am trying to understand then would try it too. Thank you both for helping me. Now my problem is solved. I don't know how to mark it solved.
To mark the thread as solved,
Select Thread Tools-> Mark thread as Solved.
I will do it for you this time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks