Creating a Custom Data Entry Form to Update Multiple Excel Records at Once

**royUK** · 01-09-2009, 02:41 PM

Here's an example.

You can filter the data using the comboboxes
Click on an item in the Listbox to populate the TextBoxes

I would suggest you add a column to contain a unique transaction ID this will then make it possible to write the textboxes contents to the sheet.

Edit: I have added reference numbers & code to amend the entries

**Scotty81** · 01-19-2009, 04:30 PM

royUK,

Thanks for the clarification. I can see that it is doable. Unfortunately, I won't take this route due to the amount of VBA code I'd have to modify to get a lot of other columns to display across the screen. (What I showed is a very simple subset of the data pile). But, what it does show me is that, besides your creative solution, it is not that there are many solutions out there that I've completely missed.

Thanks again,
Scotty81

Creating a Custom Data Entry Form to Update Multiple Excel Records at Once

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions