How to use the VBA Msgbox function to collect input and display output

preview_player
Показать описание

Рекомендации по теме
Комментарии
Автор

How to display in the msgbox the cell value contains time?
For example using vbcode: cells(1, 1) .value= time
after the code, the cells(1, 1) shows 4:54 PM because I discarded seconds by manual formatting the cell.
but then, in future use, I would like to use the value of cells(1, 1) to display in msgbox.
but it shows 0.776666111 like that, it shows decimal value.
I want it gives me the exact value on cells(1, 1), the 4:54 PM.
Please help.

arielzabatecuizon