UserForm to search, edit, add and delete data

[Kinjal Doshi]

Hi All,

I am new to UserForm and have absolutely no idea on how to go about!

Attached is a Sample File - "Order Manager Sample"

Data is in Sheet - Customer Pool
I want the UserForm to Open in Sheet "1st Step", where I have given different buttons to Search/Add/Edit/Delete an ID from Customer Pool

For Search - If I enter an ID in a text box in UserForm then it should search display all the related info of that ID in same UserForm
For Edit/Add/Delete - If I enter and ID in a text box in UserForm, then it should do either Edit/Add/Delete the data of that ID from the Sheet Customer Pool.

Do I make sense?!

Please help me on this!

Regards
Kinjal

[torachan]

I have attached a simple UserForm file which does the operations you are attempting i.e. Add/Edit/Delete/Update etc.
What you have put on your sheet is not a 'UserForm' it is a form on a sheet.
To give yourself a 'feel' look through the code, it is simple to follow and each event is easily identifiable.
The sheet is just used as a flat sheet pseudo database, there are no on-sheet formula.
torachan.

[Kinjal Doshi]

Hi Torachan,

Thanks a lot!... this is exactly what I am looking for.
I added 2 more columns and updated the code!

Really, Thanks a ton!

Regards,
Kinjal

[SKEEEETER]

Hi I came across this post and this is exactly what I need for what I am working on.


My table has 14 columns and my column for the serial number is in the last column 14. I have looked and I have been unable to work out where I need to change the code so that it works, I have succesfully been able to added the extra txt boxes and they populate correctly.

I was hopinh you might be able to point me to where I need to change it so when I place a number in the serial No textbox it looks at my column 14.

[torachan]

@SKEEEETER, your query has just flagged up today, it is frowned upon to 'hi-jack' previous threads (see forum rules) it can lead to confusion.
However, if you start your own thread and upload your workbook I will gladly assist you - I will keep a look out for your posting.

[SKEEEETER]

@SKEEEETER, your query has just flagged up today, it is frowned upon to 'hi-jack' previous threads (see forum rules) it can lead to confusion.
However, if you start your own thread and upload your workbook I will gladly assist you - I will keep a look out for your posting.

I am sorry was not aware, just thought as you posted the answer you would see my response as was only a small change. But I am pleased with myself as I have worked it and is now working as I want. What I had only added to table, this is so much better. Cheers Skeeeeter