Hi
May I request for assistance to resolve the following issues with vba code.
My userform has a search and update command buttons to correct errors in the database.
However, I could not get the right vba to populate data from multipage 3 back to workheet1 Col P to W accordingly.
The updated data seems to populate to back row 10 only, irrespective of the Name/Identity No.
Attached worksheet for your assistance.
Thank you.
Nancy
Try
Kind regards
Please Login or Register to view this content.
Leo
Hi
Thank you for the solution. I really appreciate it.
However, I do not know how to match back to my original worksheet.
May I know what (3) denotes?
Thank you.Please Login or Register to view this content.
Regards
Nancy
It is reference to colomn number
for A use 1, B use 2 D use 4 and ..............
Kind regards
Leo
Hi Leo
Thank you for the great solution.
However, when I match back to my original worksheet, it doesnt work.
Is it possible to identify and recify the code as mine cannot match back to the correct Identity.
I have updated the Clearcontent code.
[CODE][/
c.Offset(0, 13).Resize(, 4).ClearContents
Set ws = Sheet1
Set Addto = ws.Range("A65356").End(xlUp).Offset(0, 0)
Application.ScreenUpdating = False
For Each Ctrl In Frame3Apple.Controls
If Ctrl.Value = True Then
Addto.Offset(0, 15).Value = Ctrl.Caption
Set Addto = Addto.Offset(0, 1)
End If
Next Ctrl
c.Offset(0, 17).Resize(, 4).ClearContents
Set ws = Sheet1
Set Addto = ws.Range("A65356").End(xlUp).Offset(0, 0)
Application.ScreenUpdating = False
For Each Ctrl In Frame4Orange.Controls
If Ctrl.Value = True Then
Addto.Offset(0, 19).Value = Ctrl.Caption
Set Addto = Addto.Offset(0, 1)
End If
Next Ctrl
Application.ScreenUpdating = TrueCODE]
Thank you for the assistance.
Regards
Nancy
Last edited by nancyching1711; 06-27-2018 at 02:49 AM. Reason: Missed out attachment.
if it is working in file posted and not in original file
it is time for original file
Kind regards
Leo
Hi Leo
Noted your advice.
Thank you so much.
Nancy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks