Results 1 to 4 of 4

Thread: Storing and retreiving text from a separate workbook

  1. #1

    Storing and retreiving text from a separate workbook



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All,

    First off, thank you in advance for your help. Im working on a project for work and Ive been stuck on this issue for the past few weeks so your input is much appreciated because at this point Im stumpedL
    My workbook:

    I have a sheet in my workbook that contains 50 graphs with a text box beneath each graph (50 text boxes in total). The graphs show performance metrics for stores, and the text box contains notes. The idea is for a district manager to visit one of his/her stores, sit down with the manager to review the performance metrics (aka graphs), and then enter his or her action plan into the text box. The next time the district manager visits the store, he/she can sit down with the manager, pull up the previously entered action plan, and use it to check progress.
    My problem:
    My current set up for this involves a heavy amount of VBA, which is taking up too much space and causing the document to crash frequently. I currently have an edit button, which returns all previously saved notes and allows the user to enter new notes. With the notes pane open, a save button takes all of the notes (previously entered and new) and transfers them to the separate file. Im using this system for each of the 50 notes panes, and its simply taking up too much space. Do you have any recommendations for how I can keep the functionality of my workbook while reducing the file size?
    Thank you,
    Benjamin

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,820
    Articles
    0
    Excel Version
    O365
    What do you mean by a heavy amount of VBA? I have many apps with 20,000+ lines of code, and they have no problems. What does the VBA do? Are you sure it is the VBA?

  3. #3
    Quote Originally Posted by Bob Phillips View Post
    What do you mean by a heavy amount of VBA? I have many apps with 20,000+ lines of code, and they have no problems. What does the VBA do? Are you sure it is the VBA?
    No, I'm not sure it's the VBA, but that's when the file slowed down. How would you recommend doing a text box that saves entered text into a separate file upon closing the text box, and returns that text upon reopening the text box?

  4. #4
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,820
    Articles
    0
    Excel Version
    O365
    You could just store it in a hidden sheet, linking the textbox to a cell. But VBA sounds as good as anything, and it is trivial, so I can't see how that is heavy VBA nor how it would crash the file.

Posting Permissions

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