Posted to microsoft.public.excel.programming

Alberto Ast[_2_] Alberto Ast[_2_] is offline

external usenet poster

Posts: 181

userform label set enter

I have a userform label set to a specific value copied from two cells.. can I
have an enter betwen both cells value?

Me.Label5 = Range("e12").Value & Range("e13").Value

I would like it to show

ECR
123456

where
ECR is the value in cell c12
123456 is the value in cell e13

it actualy shows
ECR123456

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
useform label enter	Alberto Ast[_2_]	Excel Discussion (Misc queries)	1	December 16th 09 01:26 AM
Userform - Label	Looping through	Excel Programming	4	May 27th 09 08:20 PM
Userform Label	Steve[_9_]	Excel Discussion (Misc queries)	7	October 29th 07 09:51 PM
Userform to enter values and shown in same userform in list	helmekki[_104_]	Excel Programming	0	November 19th 05 03:23 PM
Userform blinking label	Ed	Excel Programming	2	July 17th 04 12:24 AM

All times are GMT +1. The time now is 10:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us