Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Label caption on loading a userfform
Hi,
How can I update a label caption (froma cell range) upon loading a use form? I can get it to happen with a button click, but want it to get th values from a cell ... and cann't? If you can help, that'd be great ! : -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Label caption on loading a userfform
in the Sub UserForm_Initialize(), put a line
label.caption = worksheets("Sheet1").range("A1").value A1 in sheet1 contains the value for the label caption Manges -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Label caption on loading a userfform
mangesh_yadav wrote:
*in the Sub UserForm_Initialize * Thanks Mangesh ... VERY new to this... not sure about the above .. bu will try and figure it out..... : -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Label caption on loading a userfform
in the design view, double click on the form. You will enter the mode
where you have to enter the code. Place the following code there Private Sub UserForm_Initialize() button_name.caption = worksheets("Sheet1").range"A1").value End Sub mangesh --- Message posted from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Label caption on loading a userfform
mangesh_yadav wrote:
*in the design view, double click on the form. You will enter th mode where you have to enter the code. * THAT'S what I wasn't doing .... now works perfectly. THANKS VERY MUCH :) : -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
label caption | Excel Discussion (Misc queries) | |||
Is it a comment ? or a label ? or a caption ?.... | Excel Discussion (Misc queries) | |||
Getting the Label or Caption of MenuItem Selected | Excel Programming | |||
changing the caption of a label | Excel Programming | |||
label caption | Excel Programming |