Past directly into TextBox on UserForm
 

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.

Past directly into TextBox on UserForm
 

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.

Past directly into TextBox on UserForm
 

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

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.

.