Results 1 to 2 of 2

Linking a Userform Multiple Row

Threaded View

  1. #1
    Registered User
    Join Date
    08-12-2010
    Location
    Vancouver, B.C., Canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    Linking a Userform Multiple Row

    Hi,

    I've created a button on each line of my document. This button opens up a userform and I want this userform linked to that row. At the moment, I have the button select the cell and run Macro:

    Sub EditB2()
    Range("B2").Select
    Application.Run "'Calendar test.xls'!OpenAccEntry.OpenAccEntry"
    End Sub
    Instead of selecting "B2", is there a way to determine which row the button is in and then select the next corresponding cell?

    For example: if button is in A1, I would click on button, then the macro would find what row the button is in, then select the next cell (A2) and run macro.

    Thanks,
    Jason
    Last edited by Jason Jang; 08-12-2010 at 01:29 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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