View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pswanie pswanie is offline
external usenet poster
 
Posts: 247
Default 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