If you are talking about a userform, then it is much more elegant to populate the cells using code rather than the linked cell (though that still exists)