Results 1 to 2 of 2

UserForm to Worksheet Transfer

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-06-2008
    Location
    Manchester
    MS-Off Ver
    MS Office 2003
    Posts
    161

    UserForm to Worksheet Transfer

    I have created this thread in another forum but had no joy.

    http://www.vbforums.com/showthread.php?t=566484

    I have the code on the attached TextFile that will Save the Data Input from the UserForm to the Worksheet. My problem is that as there is a fair bit of information needed on the Workbook it can take a while for the Save procedure to happen. This will become a bit tiresome for the end user with it taking a good couple of minutes for each save.

    My Save Buttons are
    Private Sub cmdSave_Click()
    Private Sub cmdFinished_Click()

    Is there a way I can speed this up?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1