refedit

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

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

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

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

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

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

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

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

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

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

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

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

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

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