+ Reply to Thread
Results 1 to 3 of 3

Cell contents referring to userform and text box to pass data to

  1. #1
    Forum Contributor
    Join Date
    02-08-2006
    Location
    UK
    MS-Off Ver
    2013
    Posts
    204

    Cell contents referring to userform and text box to pass data to

    I'm trying to pass data to a textbox in a userform. The data may go to one of several text boxes across different userforms, so rather than repeat the code for each one, I thought I would refer to the user form and text box by way of a variable. I've not done this before and don't seem to be getting it right. I've tried Datehere as long, text, string, object but it doesn't seem to work.

    The text in range I2 is the name of the userform and the text box (e.g, "Userform1.textbox3"). Does that make sense? Code below


    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    02-08-2006
    Location
    UK
    MS-Off Ver
    2013
    Posts
    204

    Re: Cell contents referring to userform and text box to pass data to

    Been doing some looking around and have got the below code which almost works.
    It seems the problem I am having is that it is not finding the name of the userform (which is in correct location and spelt correctly). If I amend the part with uformname to the actual name of the userform, it does work.

    Can someone have a quick look and let me know if they can see where I am going wrong?

    Thanks

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    02-08-2006
    Location
    UK
    MS-Off Ver
    2013
    Posts
    204

    Re: Cell contents referring to userform and text box to pass data to

    Anyone who can help at all?

+ 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