| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| mailing lable | Excel Discussion (Misc queries) | |||
| how do i add lable to the points in the chart, | Excel Discussion (Misc queries) | |||
| Userform.Lable Variables | Excel Programming | |||
| y-axis lable truncates words, why? | Charts and Charting in Excel | |||
| lable ranges in Excell | Excel Discussion (Misc queries) | |||
Threaded Mode
