Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My userform contains one label control that contain a
text caption. The problem is, I want the text caption to mirror the contents of cell "A1" at all times. So, when the userform is loaded, I want it to immediately read the value from cell "A1" and store it in my label's caption. Then, every time someone changes the contents of cell "A1" I want my label to immediately detect the change and re-load the text from cell "A1" onto the label. What would be a good way to implement this?? Would it involve using a combination of Userform_Initialize() and Worksheet_Change()?? Does anyone have any code examples? thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing the font for part of an axis label, not the whole label. | Charts and Charting in Excel | |||
Changing label caption in a Userform to an opterator value | Excel Programming | |||
Changing text size in option buttons on a userform | Excel Programming | |||
Userform - Formating Text in a Label | Excel Programming | |||
changing selected label on userform w/ a variable | Excel Programming |