+ Reply to Thread
Results 1 to 1 of 1

Refedit value - use rows and column reference for Userform

  1. #1
    Registered User
    Join Date
    07-04-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2003,2007
    Posts
    10

    Unhappy Refedit value - use rows and column reference for Userform

    Hello

    Just a small help required.

    Currently I have textboxes where i input data of which row, column etc

    I would like to change it using the refedit option so that it becomes easier

    Have attached a dummy file for reference

    As you will see when the Userform loads that I have already put the default values as 2, 12, and 5 in a text box

    2 and 12 referes to the rows

    and 5 refers to the column E where the data will be picked up from

    Now instead of entering numbers such as 2,12,5 I was wondering if i could just select the data validation range (ie. $E$2:$F$12) by inserting a refedit (instead of having textboxes) and use the values which I get from it

    ie. use the value "2" and "12" and "E" from the range

    Also in the first refedit box where i select 'B3' would it be possible to prevent me from selecting a range. (ie only a single cell should be selected not a range)

    Thank you.

    (If you want to run the macro you have to put 'B3' in the Ref edit input box and after you press ok select a folder where you want to save your outputs)
    Attached Files Attached Files

+ 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