Display data using label on userform

**stoey** · 11-27-2008, 02:34 PM

hi again,

anyone know how to display data using label on userform? I tried using offset but it doesnt work. The data I want to display is in column G. How do i go about that?

here's the code i tried

lbltitle.Caption = Offset(0, 3).Value

Thanks,

stoey

**Bob Phillips** · 11-27-2008, 02:40 PM

You have to offset from a cell, so you need to specify which cellusing theRange property.

**stoey** · 11-27-2008, 02:42 PM

hi,

can you show me a sample declaration bob?

thanks

**stoey** · 11-27-2008, 02:46 PM

hi

i tried

lbltitle.Caption = Cells.Offset(0, 6)

but it returns an error 'Run time error 1004' Application define or object define error

**royUK** · 11-27-2008, 02:50 PM

This will display the contents of F1

lbltitle.Caption = Cells(1, 1).Offset(0, 6).Value

**stoey** · 11-27-2008, 02:55 PM

hi roy,

thanks for the reply. if I want to display the content of column G1 which part should I modify?

thanks,

stoey

**shg** · 11-27-2008, 02:57 PM

lbltitle.Caption = Range("G1").Text

**stoey** · 11-27-2008, 02:59 PM

hi

i got it...i change the cells (1,1) to cells (10,1) sorry my mistake, I was referring to column G row 10. Its all working now. Thanks Roy.

Stoey

**royUK** · 11-27-2008, 03:03 PM

Why do you need the Offset? Display G10:

lbltitle.Caption = cells(10,7).Text

**stoey** · 11-27-2008, 03:17 PM

thanks shg and roy...i got it working now

**royUK** · 11-27-2008, 03:50 PM

please mark the thread solved & rate the answer(s)

**stoey** · 11-27-2008, 04:18 PM

hi,

how do I rate the answer?

thanks,

stoey

**VBA Noob** · 11-27-2008, 04:30 PM

Try marking as solved first.

Go to first post
Click Edit
Advance
Top left is a dropdown marked No prefix
Change to Solved
Tick ok

To rate a thread

Top left of Roy's post there is a symbol that looks like a silver scale. Click on that

VBA Noob