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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back