Results 1 to 5 of 5

Using Loop Macros with RefEdit controll in userform

Threaded View

  1. #1
    Forum Contributor FRIEL's Avatar
    Join Date
    03-07-2008
    Location
    Coventry
    MS-Off Ver
    2003 and 2007
    Posts
    266

    Using Loop Macros with RefEdit controll in userform

    Hi Guys

    im trying to use a userform with 2 refedit controlls on it, one is input ant one is output.
    I have what i need to do down ok when only using one cell per refedit

    but here is where i am struggling

    I want to make it so if i select multiple cells it will do the process for each cell and output accordingly.

    the way i am doing it at the miniute is

    For Each Cell In Range(RefEdit1)
    Range(RefEdit2).Value = Cell
    Next
    but i dont know how to reference to a cell in the second range (it just uses all of them at once)

    the only way i can think of doing this is to use a collection but this caould be a bit more long winded that i would like.
    Last edited by FRIEL; 09-29-2010 at 05:42 AM.
    I dont like to use code i dont understand
    it makes it hard to use in other situations
    so please try to be as clear and patent as possible with me

    Criticism is welcomed

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