Label Caption = cell value In UserForm

hello,
i m using a userfrom in my sheet. i want to link label2 = sheets("OF $").Range("D6").value


i mean i want to lable2 = cell value as link


thanx

Please Login or Register  to view this content.

Thanx davesexcel

work perfect

i have one more query?

if i want to add some text with range("d6").value
e.g
d6 = 145
i want reuslt

label caption = 145 HB

Sure thing,

Try this:

Please Login or Register  to view this content.