Ischyros
12-10-2008, 06:36 PM
I am trying to make a usferform that does a pretty simple task.
Using 2 RefEdit controls on the userform the user will do two things. First, they will select a range of cells to be scanned by a certain function of mine. Second, with the following RefEdit control they will choose the destination cell/range to output the results of the scan.
When a user selects a cell with RefEdit, lets say in this instance "A1" the RefEdit Value is "Sheet!$A$1", how can I use this RefEdit control to get the cell address. For example if I were to put a formula into the destination range the user selects.
Any ideas?
Using 2 RefEdit controls on the userform the user will do two things. First, they will select a range of cells to be scanned by a certain function of mine. Second, with the following RefEdit control they will choose the destination cell/range to output the results of the scan.
When a user selects a cell with RefEdit, lets say in this instance "A1" the RefEdit Value is "Sheet!$A$1", how can I use this RefEdit control to get the cell address. For example if I were to put a formula into the destination range the user selects.
Any ideas?