+ Reply to Thread
Results 1 to 6 of 6

Userform object reference by variable

  1. #1
    Registered User
    Join Date
    12-29-2011
    Location
    Milwaukee, Wi
    MS-Off Ver
    Excel 2007
    Posts
    12

    Userform object reference by variable

    I am attempting to create a form to track multiple lines and create a total. to do this I have the same code repeating for each "row" on the form:

    Please Login or Register  to view this content.
    I want to change all references to variable so I can repeat the code and only change the first line (EmptyRow = x)like:
    Please Login or Register  to view this content.
    but get an error :Expected Expression. Is there a way to make this work I havnt tried yet?

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Userform object reference by variable

    Please Login or Register  to view this content.
    and so forth
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    12-29-2011
    Location
    Milwaukee, Wi
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Userform object reference by variable

    Please Login or Register  to view this content.
    Compile Error:
    Expected: identifier or bracketed expression

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Userform object reference by variable

    you missed the 'controls' part ;-)

  5. #5
    Registered User
    Join Date
    12-29-2011
    Location
    Milwaukee, Wi
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Userform object reference by variable

    IRRELEVANT!



    Tyvm

  6. #6
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Userform object reference by variable

    you're welcome :-)

    please don't forget to mark the thread solved (click the 'thread tools' link at the top, then 'mark solved')

+ Reply to Thread

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