Edit existing excel records using UserForm

Hi All Gurus

I need help to create a simple edit VBA script to allow user to search and edit existing excel row records. I had created the add record button with reference to some of the site in the web.

See my attached sample

Thanks

on what basis do you want to edit the master record?

Hi mahaveersomani,

due to staff movement from one floor to another. Data entry clerk need to update by searching using Ctrl F and edit directly to the row, it is easy to make mistake. The more efficient way is use userform to search and edit. By the way the actual rows of this excel spreadsheet is 4000 over records. This is the interim data entry form before we migrate over to MS SQL AS. Thanks !

PS :- if you can show me on the search and display script will be wonderful. Thanks !

check the attached file and then tell me if there is any problem.


Thanks & REgards
MAhaveer somani

Hi Mahaveer,

that was superb fast, how about just search and view tab ? hope I am not taking much of your time .... Thanks !

Hi Mahaveer,

Can the office location, space type, space sub-type and space status to use comboBox control (drop down) for user to select during editing ?

use the attached File

User Name = User
Password = Pass

check the attached file i have changed textboxes to comboboxes...

Thanks & Regards
CA MAhaveer Somani

Hi, Can I be cheeky, I have also checked out your sheet CA MAhaveer Somani, and think it is great. I am using a lot of these to develop my own Userform however need help.
In the search, which works great, what code would I have to add to navigate up/down one record at a time, ie if I just wanted to scroll through the records. Thanks
Paul

hey dbpaul

Check the attached file.

If it was useful to you then dont forget to hit * button

Regards
CA Mahaveer Somani

Thanks Bluesky63, nice to see you happy.

Regards
CA Mahaveer Somani

Hi mahaveer,

Any idea why when we click on command button each time, the font size shrinks ? how to fix it ?


Christopher

Hi machaveer,

I modify the search to use textbox but somehow cannot input name in the search box

can help to see what have I miss up in the VB ?

go to properties of textbox and make false the locked menu....

and then tell me if there is any further problem.


by the way you can use this attached sheet in which i have unlock the textbox...

hi mahaveersomani - I need exactly what you have produced for Bluesky- any chance you could look at my work book for me and help me out with this.
I have created another editing user form which is userform 2? I need to use the Search URN box to find the record and then be able to edit the record and have the option to update the data or delete from the sheet.

I do have date/times which I need to have the formats i.e DD/MM/YY, HH/MM/SS. thanks
If you could help me out that would be great.