Results 1 to 2 of 2

Thread: refresh items on form in excel

  1. Jun 20th, 2005, 02:21 AM #1
    zigraj
    zigraj is offline

    Thread Starter
    Junior Member
    Join Date
    Sep 2003
    Location
    Slovakia
    Posts
    20

    refresh items on form in excel

    Hello,
    I need some code of refreshing items on form which is shoved a front of excel sheet.
    These items are reading data from range of sheet.
    For example form is reading first column and I would like to see on form in one item context of each range from first column.
    Thank You

    Radovan Zigraj
    Reply With Quote Reply With Quote
  2. Jun 20th, 2005, 02:44 AM #2
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: refresh items on form in excel

    What code do you have at the moment?

    You may need a couple of variables: Workbook, worksheet, range
    Then you need to read in the range values by looping through the specified range. For this, read up on Range.Cells.

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width