| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to put the value form cell into the msgbox
Hi
msgbox activecell.value or if you have a date you may use something like msgbox format(activecell.value,"MM/DD/YYYY") -- Regards Frank Kabel Frankfurt, Germany Jacek wrote: Hi everybody, I would like to create the msgbox, which shows the value (exactly the date) of one selected cell. If smb would help me I will be grateful. I don't know how to make the link to the cell. best regards, Jacek |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to put the value form cell into the msgbox
Hi everybody,
I would like to create the msgbox, which shows the value (exactly the date) of one selected cell. If smb would help me I will be grateful. I don't know how to make the link to the cell. best regards, Jacek |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to put the value form cell into the msgbox
Thanks a lot, it really works.
Best regards, Jacek Uzytkownik "Frank Kabel" napisal w wiadomosci ... Hi msgbox activecell.value or if you have a date you may use something like msgbox format(activecell.value,"MM/DD/YYYY") -- Regards Frank Kabel Frankfurt, Germany Jacek wrote: Hi everybody, I would like to create the msgbox, which shows the value (exactly the date) of one selected cell. If smb would help me I will be grateful. I don't know how to make the link to the cell. best regards, Jacek |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to put the value form cell into the msgbox
or
msgbox ActiveCell.Text -- Regards, Tom Ogilvy "Frank Kabel" wrote in message ... Hi msgbox activecell.value or if you have a date you may use something like msgbox format(activecell.value,"MM/DD/YYYY") -- Regards Frank Kabel Frankfurt, Germany Jacek wrote: Hi everybody, I would like to create the msgbox, which shows the value (exactly the date) of one selected cell. If smb would help me I will be grateful. I don't know how to make the link to the cell. best regards, Jacek |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel msgbox when cell range is clicked | Excel Discussion (Misc queries) | |||
| msgBox after update a cell | Excel Discussion (Misc queries) | |||
| display cell value in msgbox formatted as % | Excel Discussion (Misc queries) | |||
| MsgBox for a range and not one cell change please: | Excel Programming | |||
| Form will not refresh without an unneeded msgbox | Excel Programming | |||
Linear Mode
