Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform textbox | Excel Worksheet Functions | |||
Autofill userform textbox | Excel Programming | |||
Code to edit directly in cells from userform | Excel Programming | |||
Code to edit directly in cells from userform | Excel Programming | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |