| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Contents as text in Msg Box
Hi
Is there any way to take the contents of a cell & add that to the text you programme into a Msg Box in VB? For example, lets say cell A1 has the following formula "=Now()", meaning text that says "10/05/06 13:47" & I want the Msg Box to read "You Logged Out At 10/05/06 13:47." Is there a way of sinking this formula into the VB code for a Msg Box? On a spreadsheet i would obviously use (="You Logged Out At "&A1&"."), but VB is getting confusing! Any help gratefully receieved cheers jb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell contents, then paste into the same cell with other text. | Excel Discussion (Misc queries) | |||
| Can I out the contents of a text box into a cell? | Excel Discussion (Misc queries) | |||
| Display contents of cell in another cell as part of text string? | New Users to Excel | |||
| evaluating text cell contents | Excel Discussion (Misc queries) | |||
| Cell only shows link in text, not contents of reference cell | New Users to Excel | |||
Threaded Mode
