lable caption
i get a object required msg when using this code
"Bob Phillips" wrote:
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" wrote in message
...
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
|