Display Cell Value on UserForm Label

Hi,

Anyone knows how to display a cell value from worksheet to Userform Label?
I have a worksheet with cell range O3 which contains a time value like 00:16:00 and I would like to display that value using label on my Userform. Also, I would like that label on my Userform to be updated as well each time the cell value on column O row 3 is being changed. I appreciate any ideas. thanks

Regards,

Burke

Hello Burke,

To copy a cell value to a UserForm Label...

Please Login or Register  to view this content.

As for the auto-updating, will the user be changing the cell's value or something else?

Sincerely,
Leith Ross

Hi Leith,

Thank you very much for replying. As for your question

Originally Posted by leith

As for the auto-updating, will the user be changing the cell's value or something else?

The cell value automatically change itself once any of the columns I have changes. Say if I have the time value of 12:00:00 on column A and 12:15:00 on column B result is 00:15:00 which is in Column C. Column C updates when column A and B are being changed. But only a particular cell value is being changed. I have tried your code and the result I got is 1.111111111 not sure why. here is the code I wrote:

Please Login or Register  to view this content.

Any idea what's causing it to display 1.111111? The cell value on the worksheet is a time value.

Regards,

Burke

Hello Burke,

I can't reproduce your problem. I added a UserForm with a Label and placed the same code in the Initialize event. The caption displayed the time value and not a number.

Sincerely,
Leith Ross

Hi Leith,

My bad...I have a code placed on the Userform_Activate and I remove it and voila! The correct value appeared. Thank you so much for your assistance and quick answer.

Regards,

Burke

Hi Leith,

By the way, how does the auto update works in this manner?

Regards,

Burke