+ Reply to Thread
Results 1 to 5 of 5

Is it possible to use textbox value from userform as a Row or Column Reference

  1. #1
    Registered User
    Join Date
    02-07-2014
    Location
    India
    MS-Off Ver
    Excel 2003, Excel 2007, Excel 2010
    Posts
    4

    Question Is it possible to use textbox value from userform as a Row or Column Reference

    Dear Experts,

    Is it possible to use textbox value from userform as a Row or Column Reference.
    For e.g. i want users to enter the row or column in a textbox which should then be used in the following code:
    Please Login or Register  to view this content.
    Many thanks in advance !
    Last edited by Leith Ross; 04-20-2014 at 02:44 AM. Reason: Added Code Tags

  2. #2
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Karlstad, Sweden
    MS-Off Ver
    Excel 2016
    Posts
    232

    Re: Is it possible to use textbox value from userform as a Row or Column Reference

    I have added a simple code that might help you.

    SelectRows.xlsm
    1. Reply to thread and inform if suggestion was helpful or not
    2. Click on the star (=Add Reputation) if you think someone helped you
    3. Mark [SOLVED] to this thread if solution was found. (On Menu "Thread Tools" > "Mark this thread as solved")

  3. #3
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Is it possible to use textbox value from userform as a Row or Column Reference

    Hi,,

    You can use something like this:

    Please Login or Register  to view this content.
    If you want the user to be able to select the rows with the mouse instead of entering values into a textbox, you can also think of using the RefEdit control on the userform to collect the range/rows...

    BTW: Welcome to the forum
    Last edited by RudiS; 04-20-2014 at 03:11 AM.
    Regards,
    Rudi

  4. #4
    Registered User
    Join Date
    02-07-2014
    Location
    India
    MS-Off Ver
    Excel 2003, Excel 2007, Excel 2010
    Posts
    4

    Re: Is it possible to use textbox value from userform as a Row or Column Reference

    Works like a charm..thank you so much !!
    Cheers

  5. #5
    Registered User
    Join Date
    02-07-2014
    Location
    India
    MS-Off Ver
    Excel 2003, Excel 2007, Excel 2010
    Posts
    4

    Re: Is it possible to use textbox value from userform as a Row or Column Reference

    Wow that works too...Awesome !

    & thank you so much Rudi for the suggestion & welcome

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Userform textbox to reference active cell with offset
    By Nitefox in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 6
    Last Post: 12-15-2013, 01:38 AM
  2. [SOLVED] Userform textbox to update column (comment) ?
    By waihar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-08-2013, 10:55 PM
  3. Column values to be shonw in userform textbox
    By Samtalk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2012, 09:28 AM
  4. Reference a userform numbered textbox in vba
    By Khaos176 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-26-2009, 10:04 AM
  5. userform textbox that searches column b
    By iturnrocks in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-05-2008, 02:08 PM

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