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

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

IntroToIS BYU

4 года назад

12,600 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@arielzabatecuizon5147
@arielzabatecuizon5147 - 30.01.2021 12:42

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.

Ответить