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

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

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

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