User form needs to update entry rather than add a new one

**henryBukowski** · 06-05-2015, 11:15 AM

I have a user form transferring data to a new line in a spreadsheet. It's something like as follows:

Please Login or Register  to view this content.

I have added a function to update existing data entries. when a user clicks on the active line, the data from the active line is put back into the user form, so that the user can change and update the data:

Please Login or Register  to view this content.

However, at the moment instead of updating the same record, my code is adding a whole new entry.

could anybody suggest a modification which makes it so that this function replaces the existing entry?

Linked: http://www.mrexcel.com/forum/excel-q...ml#post4176860

**mehmetcik** · 06-05-2015, 11:57 AM

You need a Public flag to monitor when you read an existing entry and a public variable to store the row number

Then you can use your existing code with a small modification.

**henryBukowski** · 06-05-2015, 12:01 PM

Thanks mehmetcik :

I'm worried that the code I've posted makes it looks like I understand more than I do - could you please illustrate this with an example?
As brief as you'd like.

Many thanks for your response.

**mehmetcik** · 06-05-2015, 06:37 PM

In Normal Module

Please Login or Register  to view this content.

In Macro Module

Please Login or Register  to view this content.

**mehmetcik** · 06-05-2015, 06:51 PM

You are making a lot of basic errors in your Code.

You should read all your data from excel to visual basic in one read action

Please Login or Register  to view this content.

Then you transfer your data into your textboxes using something like

Please Login or Register  to view this content.

But your textboxes need to have consistent names

You can load List and comboboxes the same way

Please Login or Register  to view this content.

You write your data back to excel in the reverse manner.

**henryBukowski** · 06-09-2015, 05:24 AM

Thanks for your replies mehmetcik - I will review my code so as to make it more efficient and less error strewn!
Wiith your help I have been able to implement the 'entry update' which now works!

One issue!

Currently the database does not seem very good at recognising the data already there. When there was data in each line it worked well and a new line appeaered beaneath the previous.
However I then deleted all data to start from scratch but this doesn't appear to have reset the lines of entry which are still being added in on the 10th row, even though the 9 rows above are now empty.

Is this rectifiable?

I appreciate your help

**mehmetcik** · 06-09-2015, 05:36 PM

The last row is not reset by excel until it is saved and re-opened.

Easiest way to sole this is to ammend this line:

Please Login or Register  to view this content.

Try this instead

Please Login or Register  to view this content.

User form needs to update entry rather than add a new one

LinkBack

Thread Tools

Rate This Thread

Display

User form needs to update entry rather than add a new one

Re: User form needs to update entry rather than add a new one

Re: User form needs to update entry rather than add a new one

Re: User form needs to update entry rather than add a new one

Re: User form needs to update entry rather than add a new one

Re: User form needs to update entry rather than add a new one

Re: User form needs to update entry rather than add a new one

Thread Information

Users Browsing this Thread

Similar Threads

Pull Worksheet Cell Data into a User Form Text box and have it update as the form is fille

user form entry

Match new password to specific user and update list via custom user form

Filling form fields via worksheet dropdowns, user update via form, change form color

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions