Using the RefEdit Control 
Using the RefEdit Control
by WiseOwl
Video Lecture 19 of 20
Not yet rated
Views: 509
Date Added: May 16, 2017

Lecture Description

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link to make a donation. Thanks for watching!

By Andrew Gould
Download files here - 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.

Course Index

Course Description

This tutorial explains how to create user forms in Excel VBA taking you from the very basics of drawing and formatting forms, through discussions of the various controls that you can add, and on to even more advanced features.


There are no comments. Be the first to post one.
  Post comment as a guest user.
Click to login or register:
Your name:
Your email:
(will not appear)
Your comment:
(max. 1000 characters)
Are you human? (Sorry)