VBA function to update info based on form input

**Reinhard.S** · 12-07-2017, 12:09 AM

Hi there! I am a fairly new VBA coder and have learned everything so far from online resources and YouTube tutorials. Currently working on an Excel VBA form that would allow users to update client information in a database over time without actually going into the raw data. I have a findvalue function that works; however, it is messy and I fear it is slowing my system down as there are 93 data elements that need to be updated any time a client update is made. Any ideas on how I can turn what I have into a cleaner, faster working process?

Thanks in advance for any insights!

**Norie** · 12-07-2017, 12:25 AM

Where's the 'findvalue' function you mention?

The only 'findvalue' I can find is a variable that's used in some subs to search various columns and that's only ever being used in simple code like this.

Please Login or Register  to view this content.

Have you investigated what's actually slowing things down?

PS You could cut the code in the Update sub down a bit by using a loop but that probably won't have an impact on speed.

Please Login or Register  to view this content.

VBA function to update info based on form input

LinkBack

Thread Tools

Rate This Thread

Display

VBA function to update info based on form input

Re: VBA function to update info based on form input

Thread Information

Users Browsing this Thread

Similar Threads

How to automatically update info based on blank cell

Form input to update second sheet - Im lost :(

Table Update based on column info.

[SOLVED] Form input to update list

Data Input Form with number of line items based on user input

Input Box based on Another Cell Info Macro

Looping a data input form based on form option

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions