PDA

View Full Version : How to put together caption



obivan
05-16-2009, 03:25 AM
Hi I would like to put into caption of button value form two cells.
Cells (1,1) contains date for example 9:00:00 and cells(1,2) contains string for example HELLO. Then on surface of button will be 9:00:00 HELLO.
How can I do it?
Thank you for your help

obivan

Bob Phillips
05-16-2009, 04:40 AM
Format(Cells(1,1).Value, "hh:mm:ss") & Cells(1,2).Value)

obivan
05-16-2009, 11:37 AM
Hi xld, thank a lot.
obivan