+ Reply to Thread
Results 1 to 3 of 3

Clear RefEdit Selection in Userform

  1. #1
    Registered User
    Join Date
    08-27-2014
    Location
    Florida, U.S.
    MS-Off Ver
    2010
    Posts
    20

    Clear RefEdit Selection in Userform

    Hello and thank you for taking the time to look at this query.

    Simplified: Is it possible to clear contents in a RefEdit box inside of a userform?

    Explanation: I have searched my Excel Book and the internet for an answer and cannot find a solution. I have inherited a macro my company uses to run significance tests on ranges of data. The creator used RefEdit controls for this process. I would like to be able to clear the contents of certain RefEdit controls once the user runs the significance test so the base can remain the same but allow the user to sig test another column. Basically, once commandbutton1 is clicked I would like to clear half the userform inputs.

    Capture.JPG

    In the image the names of the RefEdits are RefEdit2, RefEdit6, & RefEdit7. Is this possible?

  2. #2
    Valued Forum Contributor Neil_'s Avatar
    Join Date
    04-19-2013
    Location
    Yorkshire
    MS-Off Ver
    Office 365 Enterprise E3 2013 / 2016
    Posts
    479

    Re: Clear RefEdit Selection in Userform

    RefEdit2 = vbNullString
    Frob first, tweak later

  3. #3
    Registered User
    Join Date
    08-27-2014
    Location
    Florida, U.S.
    MS-Off Ver
    2010
    Posts
    20

    Re: Clear RefEdit Selection in Userform

    So simple! Thank you.

+ 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. Refedit value - use rows and column reference for Userform
    By viply1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-01-2013, 07:21 AM
  2. Userform RefEdit to populate formula in macro
    By jtw1121 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2012, 01:43 PM
  3. [SOLVED] Userform textbox used as refedit
    By Jacques Grobler in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 06-29-2012, 01:45 AM
  4. Using Loop Macros with RefEdit controll in userform
    By FRIEL in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2010, 05:41 AM
  5. Userform Error with Blank RefEdit.
    By Baziwan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-05-2010, 01:50 AM
  6. Cant Seem To Deselct RefEdit Box On Userform
    By JR@SGC in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2007, 08:28 AM
  7. Refedit - Limit selection to only one cell
    By Andibevan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2006, 05:55 AM
  8. [SOLVED] RefEdit on Userform to pick up range in another workbook
    By jase in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-02-2005, 12:05 PM

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