lable caption

[pswanie]

i got userfrom, multipage, lable1 on page2

how do i get the caption of that label to pick one cell down every time i
open the userform? on first open it wil show c1. second open it will show c2
thirt open c3. untill it gets to a cell with no data and start back at c1

 

[Bob Phillips]

Declare a variable at the start of the standard code module

Public mCaptionRow As Long

and in the form activate, use

mCaptionRow = mCaptionRow +1
Multipage1.Labelname.Caption = Worksheets("Sheet1").Cells(mCaptionRow,
"C").Value

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[pswanie]

i get a object required msg when using this code

Declare a variable at the start of the standard code module

Public mCaptionRow As Long

and in the form activate, use

mCaptionRow = mCaptionRow +1
Multipage1.Labelname.Caption = Worksheets("Sheet1").Cells(mCaptionRow,
"C").Value

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)