Results 1 to 7 of 7

I need to send a target.row variable to a User form Initialization sub. Is it Possible?

Threaded View

  1. #1
    Registered User
    Join Date
    05-24-2013
    Location
    Las Vegas
    MS-Off Ver
    Excel 2007
    Posts
    26

    I need to send a target.row variable to a User form Initialization sub. Is it Possible?

    Hello all,

    I thought I would pose another question to the forum as I'm almost out of hair to pull out! I guess when in doubt, turn to those who know more than you do, right? Here is my situation. I have a worksheet that watches a range for changes. When an entry is made in the range, a user form is called. I am pre-populating the user form with information in columns 1-4 of the activeCell.row. However, if the excel installation uses the default "After pressing enter, move selection down" the activeCell.row uses the wrong row number. Since a user form initialization does not take an argument, how can I use the target.row from the sub that called the userform instead of the activecell.row? Is there a way to return the row number of the cell that was most recently changed so that a user form can use it?

    I thank you all for your continued assistance and willingness to assist in furthering my Knowledge.

    Scott
    Last edited by sdavison; 07-26-2013 at 07:33 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Re: Please help for Excel User form send data for multiple worksheets
    By gopala in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-22-2013, 04:08 AM
  2. User form to add attachments and send the form and attachments via outlook
    By scorchio83 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2013, 03:46 AM
  3. VBA: Create User Form That Takes Variable User Inputs
    By sanjeevpandey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-18-2013, 06:14 PM
  4. Using the target command to start user form macro
    By HP RodNuclear in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-07-2011, 02:45 PM
  5. User form and send mail
    By wizard5353 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-27-2005, 11:05 AM

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