Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am running a sub that updates a cell in excel and then in turn updates the
caption property of my button to the value in the cell ('AlarmTime', which is a number representing a date which is appropriately formatted to update the caption: Frm_DataEntry.Controls.Item("Btn_CALLBACKDATE").Ca ption = Format(dbAlarmTime, "dddd dd mmmm hh:hh") I have stepped through all the code and it all works exactly as it should except for the last line (the line above that updates the button). I replaced the number/date variable woith a string value to check my referencing of the button... again it updated perfectly, so my only possible explanation is that the button doesn't like my formatting, but then I use it elsewhere to update the button and increment the time by one hour (the subject of my last post) and although there's a bit of a bug in that it updates a minute too much, it does update, so I am totally confounded as to what could be the problem! Anyone any ideas? Thanks in advance, regards, Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Set Button Caption | Excel Programming | |||
How to change Button Caption? | Excel Programming | |||
Update the time in a form caption | Excel Programming | |||
Userform - Label Caption - How to update from a variable | Excel Programming | |||
Caption of a button | Excel Programming |