Textbox Info

[oberon.black]

I am using the following code to get info from a cell in my spreadsheet and add it to my userform textbox:

Please Login or Register  to view this content.

-Problem-
I need to have the information from cells 'A12 & E12' inserted in the textbox and then separated by a comma(,).

Can some one help me with the code for this.

Thank you for your support.

[dominicb]

Good evening oberon.black

This line should do the trick.

TextBox2.Value = Range("A12") & "," & Range("E12")

HTH

DominicB

[oberon.black]

Like a charm. But tell me why do I remove the .value?

[Dave Peterson]

You want to use:

TextBox2.Value = Range("A12").Value & "," & Range("E12").Value

???

I like to use that syntax, too. .Value is the default property a range object
(so it's not always required).

But I think it makes for better reading/coding to always use the property you
want. You never have to worry about which property you meant.



"oberon.black" wrote:
>
> Like a charm. But tell me why do I remove the .value?
>
> --
> oberon.black
> ------------------------------------------------------------------------
> oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
> View this thread: http://www.excelforum.com/showthread...hreadid=468380

--

Dave Peterson

[oberon.black]

Ok, Thanks