Concatenate option button with combobox values

hi....i have the following code...

Please Login or Register  to view this content.

It works fine....however i would to concatenate this

Please Login or Register  to view this content.

with this

Please Login or Register  to view this content.

into the same cell....but I don't know how....can someone show me? Thanks in advance...you guys always have the answers

Hi Humboldtguy
Just concatenate both of them at the end !

Please Login or Register  to view this content.

Hi Wizz, thanks for the response....this opens up a whole new problem for me unfortunately.....

The thing that I am doing actually is combining an hour selection combobox, a minute selection combobox, and AM or PM from option buttons. After these 3 things are combined, the formatting ends up giving me a number like 0.33333 instead of say 7:00 AM. Is there any way to make this work without resorting to military time?

For sure. There are 2 options.

1) Go to column "B" and change the cell format to Time.
2) use the 'TimeValue' code. Press F1 to get the full info.

Hope this does the trick!

hi Wizz....i read the help on timevalue, but I really don't know how to use it....as for the cell formatting, it is already formatted as time.

Can you upload the workbook (or a dummy)? So I can help you better !