Get Data from a cell into TextBox1 in Userform?

**excellenthelp** · 03-22-2014, 05:06 AM

Hello Excellers,

I am struggling with making the userform able to get the data from a cell in a worksheet and pass it to textbox1 when it is opened. The data from the cell is refreshed every time the workbook opens (using external data: web source data).

The code I wrote on the userform is:

Formula:

Please Login or Register  to view this content.

What am I writing erroneously?

Let me know! Thanks!!!

**excellenthelp** · 03-22-2014, 05:48 AM

Or... the textbox1 can be replaced with a Label as well...

Thanks!

**HaHoBe** · 03-22-2014, 06:34 AM

Hi, excellenthelp,

you don´t state what isn´t working.

Maybe use the Activate-event of the Userform (code goes behind the UF):

Please Login or Register  to view this content.

Ciao,
Holger

**excellenthelp** · 03-22-2014, 06:42 AM

Holger,

The textbox kept returning EMPTY.

Here's what I did... I changed from a textbox to a label and wrote a line to automatically update the caption of the label when a cell value is updated. This works.

I will look into your code soon.

Thanks!