Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    May 2005
    Location
    Wilcox, Saskatchewan
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Refresh worksheet (Excel 2000)

    I am wondering if anyone knows a way to refresh a workbook after a macro is ran. Currently I have a file inporting into excel from outlook and the data from outlook isfilling in a list box I have created. , The data that is beening iportted is pasted into a seperate worksheet then the where the list box is located. The issure is that on the sheet with the list box the listbox is actually showing some of the data from the import sheet. if I goto tool> option calculate the form refreshes. so I add calculate at the end of the import code and this doesnt work.

    I am just checking to see if someout there knows what I am talking about and has a slution
    Thank You

  2. #2
    2 Star Lounger
    Join Date
    May 2005
    Location
    Wilcox, Saskatchewan
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Refresh worksheet (Excel 2000)

    Aonther wierd thing to add is that is I click properties behine the list box, and move to autoload and set it to True, the list box does not refresh

Posting Permissions

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