Excel VBA Forms Part 19 - Using the RefEdit Control

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link www.wiseowl.co... to make a donation. Thanks for watching!
You can buy our Introduction to Excel VBA book here www.lulu.com/s...
By Andrew Gould
Download files here www.wiseowl.co...
www.wiseowl.co.uk - The RefEdit control provides you with a way to select cells from the comfort of a user form in Excel. This video explains how to make the RefEdit control available, how to use it to select cells and how to use the value it returns to manipulate the cells you've selected. The video also includes a section on a few potential issues with the RefEdit control and shows a couple of alternative techniques using the Application.InputBox method.
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio and more

[@favorite80]

For me, your tutorials are THE BEST! (I don't even need to speed-up the playback speed, since your talking speed is exactly what I like!)

[@WiseOwlTutorials]

Happy to hear that you're finding the videos useful. Thanks for watching and taking the time to leave a comment!

[@waynelambert]

Quick tip for paste special values... the quickest way is actually to press the keyboard button which represents the right mouse button (just to the right of the space bar) and 'V'. It's the same speed as a normal control and 'v' for paste.

[@valeriafilatova8119]

Thank you!

[@WiseOwlTutorials]

You're very welcome Valeria!

[@victoropere2107]

lots of respect to you sir..............................thanks

[@grape142]

Excellent, as usual.

[@jessicamewald]

Thank you!!!!!

[@katiadelrosario4846]

Hi, excellent class, It is my first timeto see the use of RefEdit with Ctrl for non-contiguous cells.
The example is for copy, could you help me because I have to use each range selected in RefEdit1with CTRL, to reconize each and concatenate then, row by row.
I did it but I create several RefEdit, after see your video, I think could be better to use only one RefEdit to select with control all the cells or named range I want.
Could you help me on that? thanks in advance

[@luong87mipec]

quá hay

[@mmbcampus]

Background:
In my Excel userform, I have
RefEdit control/ 03 Radio buttons/ A label (when click, it opens a hyperlink)/ Command to run the code.
I can select range from the sheet with RefEdit control and when I press the command button, Userform/Excel is working absolutely fine.
When a problem arises:
If I click RefEdit to select range from the sheet (RefEdit in Focus) and instead of selecting sheet range if I click on the hyperlink button, then the problem arises- Else Excel does not respond, or userform disappears automatically, or Excel freeze.
When a problem does not arise:
If I click RefEdit to select range from the sheet (RefEdit in Focus) and instead of selecting sheet range if I click on the command button or Ration button.
Only problem is coming when RefEdit is in Focus and Hyperlink label are click.
Can you please help with this? I know I can solve this with Application.Input method or If I create hyperlink command button instead of hyperlink label. But I want to know why this problem is occurring?

[@WiseOwlTutorials]

Hi there, I'm sorry I don't know the answer. You may have more success posting this question at StackOverflow.com

[@easthighfootball1]

How can I use F4 to toggle between absolute and relative references with refedit?

[@konradmarzec1029]

While adding non-contigious range to refedit, macro generating chart returns error 1004 refering to setsourceproperty. How to solve it?

[@konradmarzec1029]

Hi, I was struggeling all the time, the answer is to exchange ";" on ",". Below sample of code:
Dim s1$, c As Chart
s1 = RefEdit1.Value
s1 = WorksheetFunction.Substitute(s1, ";", ",")
Set c = Charts.Add
c.SetSourceData Range(s1)
BR

[@ceyhunyesilirmak4611]

I was suffering the same problem as well I found a solution www.officetooltips.com/office_2016/tips/change_the_semicolon_to_a_comma_or_vice_versa.html do this step by step but If your decimal symbol where is described at the top of Customize Format dialog box is comma too, change it comma.