Past directly into TextBox on UserForm

[DonB]

I would like to right click a worksheet cell, copy its
data, open an existing/"homemade" UserForm, select a
TextBox on it, right click, then paste. How? Any ideas
would be much appreciated.

 

[Guest]

Hi DonB,

Another approach might be to use the RefEdit control (say this is named 'refedit1'), assuming that your macro will be using the cell value as input.

So If you wanted to set a variable (named var1 below) to whatever was in the cell, then say

var1=range(refedit1.text).value

This line will return the value in the cell range selected.

I hope this is helpful.

SuperJas.




----- DonB wrote: -----

I would like to right click a worksheet cell, copy its
data, open an existing/"homemade" UserForm, select a
TextBox on it, right click, then paste. How? Any ideas
would be much appreciated.

 

[DonB]

Hi SuperJaz

I'll give it a try - and try to remember how to
spell "paste"

Thanks DonB

-----Original Message-----
Hi DonB,

Another approach might be to use the RefEdit control (say

this is named 'refedit1'), assuming that your macro will
be using the cell value as input.

So If you wanted to set a variable (named var1 below) to

whatever was in the cell, then say