How to put the value form cell into the msgbox

F

Frank Kabel

Hi
msgbox activecell.value

or if you have a date you may use something like
msgbox format(activecell.value,"MM/DD/YYYY")
 
J

Jacek

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB Date Format 8
MsgBox to display [hh]:mm 6
Need help-For loop 3
dd/mm converted to mm/dd 4
Date Range Macro 2
Detect UPPERCASE in cell value? 7
Finding Duplicate Entries - Saving Worksheet if none found 3
Date format from UserForm 3

Top