Create Userform to Edit, View, Remove and Find next/ previous data

Hi,

Attached here my sample of userform to add data only.

Can anyone help me on how to create for
1) Viewing
2) Editing
3) Remove
4) Find Next /Previous.

The key indicator is at column H, PF number

Hi Farid,

You're example has several missing PF numbers. What is the criterion for Previous/Next categorization?

Hi Xladept,


Attached my updated workbook. Sorry for overlooked on that part.


The criteria previous/next is same as normal database system.
i.e. if you are in the 2nd row of data. previous will be on the 1st row and next will on the 3rd row.

PF numbers will be start on "triple Zero" (000) on the first 3 characters. I have to use apostrophe ( ' ) or set format as text. Does it will impact searching method?

Hi Farid,

I added a button and a textbox along with an edit option in your add record button. I figure that for next and previous the user could just change the row number

Userform.xlsm

Hi xladept.

Thanks a lot especially by introducing row number to replace find next/previous. It Working Fine.
But Edit button does not reflect to Sheets("Data") for both column "A & B". Data for both column may NOT be same.

I thought maybe on this part. the rest in sheets("ORIGINATOR") is reflected.

Please Login or Register  to view this content.

Hi Farid,

You're welcome and thanks for the rep!

I'll check it out:|

Try this:Userform.xlsm

Hi Xladept,

Many Thanks for your assistance and expertise skills.

Hi Farid,

You're welcome - I just keep adding commas 'til I get to where I want it