+ Reply to Thread
Results 1 to 4 of 4

Userform to input information into cells

  1. #1
    Registered User
    Join Date
    02-21-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Office 2010
    Posts
    96

    Userform to input information into cells

    Hi. I have a userform i have created with text boxes that users will enter information in and select a range of data they want the information to be displayed in using the refedit control. I am trying to figure out how to properly copy the information into the cells. I tried using the Offset function to skip to the next cell over but it counts the whole range as 1 cell then moves to the next cell outside the range i select and places the value there. One of the values the user inputs into the form is a hyperlink. One of the textboxes is meant for a web address as well that i want to create a hyperlink out of with a friendly name. Having trouble on this as well. I get a run-time error '438': Object doesn't support this property or method on the hyperlink line at the bottom of code:

    Please Login or Register  to view this content.
    Any help is appreciated. Thanks!

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Userform to input information into cells

    Try something like this...

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-21-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Office 2010
    Posts
    96

    Re: Userform to input information into cells

    Quote Originally Posted by AlphaFrog View Post
    Try something like this...

    Please Login or Register  to view this content.
    And that worked! Thanks Alpha.

    Completed Code:
    Please Login or Register  to view this content.
    Last edited by Spritz; 05-30-2013 at 12:54 PM.

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Userform to input information into cells

    You're welcome.

    You don't need these any more.
    Please Login or Register  to view this content.

+ Reply to Thread

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