refedit

  1. M

    Triggering Refedit change event

    I'm using 3 refedit controls in a form and for some reason I can't figure out how to get it to trigger an event when the value of the control is changed. What I'd like to do is make it trigger an event so that when someone clicks onto the worksheet to change the range, it would cause the focus...
  2. P

    How to extract the first range from a refedit selection

    I am using the refedit control on my userform. Is there a way to extract the first range from my selection so I can offset it to retrieve other data from that row as well from "Sheet1" within workbook named "SDPF". Example: With the refedit, I am selecting the range(H1044:H1061). However, to...
  3. M

    VBA- Error while Using RefEdit for copying range between workbooks

    I wanted to copy some not continous ranges from several workbook/ worksheets to a specific sheet. I am using a userform and RefEdit control on that. But the Excel freezs each time I am calling the form and addressing the ranges! I can't do anything except End Excel! Here is my Code...
  4. H

    RefEdit modify user input string

    Hi VBA Gurus, I am trying to take the cell a user clicks and allow them to add to the input box string. I have figured out how to strip the tab name and just show the Cell after selection but when I try to modify the input box, it simply overwrites it. For example say I want the RefEdit box...
  5. J

    RefEdit doesn't respect tables (listobjects)

    I've got a UserForm with a RefEdit in it. When I start up the form, I click the RefEdit's button on the side, then I can select a range, and the RefEdit populates: Sheet1!$A$1:$Z$10, for example. But if Sheet1 has a table on it, and I start selecting within that table, I expect...
  6. R

    RefEdit Userform Math

    Trying to use a userform to allow user to select ranges of data and quickly calculate the percent difference. I have been working on this for hours with no positive outcome. I can get it to work when you select one cell (not the code I pasted), but I cannot get ranges to work. If someone know...
  7. R

    VBA Form - Select Column Only

    Hi There, I'm designing a simple form, and using some RefEdit controls to select columns. However, what I want to do is restrict this to just select one single column. As it currently stands, I can have anything selected - columns, rows or ranges. I haven't played with any of the default...
  8. D

    VBA UserForm RefEdit ==> Paste range selected in new sheet

    Hi, I have got a UserForm set up to select a range (using RefEdit), amongst other things. When I hit the 'Enter' button, I want the range to that I have selected to be pasted onto the new sheet. I have made sure that the RefEdit.Value is converted to a Range prior to copying, but I am having...
  9. T

    Userform can't close if refedit in focus

    Hey guys. I've got a userform with a few different refedit objects, and if one of the refedit objects is in focus, or in use, when the user presses the cancel button to close the form the form will close, but Excel becomes stuck in a "select a cell" mode for the previously in focus refedit...
  10. T

    Userform disappears when moving from one refedit to another in an tabstrip.

    Hi everyone, I'm trying to create a "Workbook Aggregator". That is an excel file, that given a variable range, and some data, can match the variables automatically, and aggregate all the data into a single excel file. What I'm doing is looping through files in a directory, opening each file...
  11. K

    Problems with embedded RefEdit control on worksheet

    Hi, I have embedded a RefEdit control directly in a worksheet, but it doesn't seem to work. Essentially I would like the user to select a range, or ranges, so that the program can store the address in a linked cell. However, the control doesn't seem to take in the selected range. I have...
  12. E

    RefEdit with a color frame-type selecting tool

    Hello, It's my first time posting on this forum, but I couldn't find an answer anywhere else and it got me really frustrated. Is it possible to somehow create and control the colorful range selection frames that appear when you type formulas with references to cell addresses? For instance when...
  13. Rauber

    How can I do math operations using RefEdit?

    Help please, I have a Matriz on Worksheet(3) (6x6 for example), and I'd like to print this Matriz on Worksheet(2), but just part of it, cause the user is gonna select part of the Matriz( for example: the user select a matriz3x3 from the original one 6x6, to be printed on worksheet(2)). I've...
  14. Jaafar Tribak

    Cool RefEdit Alternative - (Made with a standard TextBox !)

    Hi all. In a previous thread ,our member Jon Von Der Heyden kindly brought my attention to this recent blog by (John Peltier) about using RefEdit control alternatives. This is what gave me the idea to work on the solution I am providing here. We know all too well how buggy and unreliable the...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top