Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox Contents
Hi, I have a messagebox, that contains certain information that change based on what in input in a cell on the sheet. I have written th msgbox that i need, but the way i thought i could insert the cel contents didn't work. Can someone please help....I need the [date1] t show the contents of the specified range instead of "[date1]"..... Code: Sub Week1Sun() Dim date1 as variant [date1] = sheets("sheet1").range("c1") If sheets("sheet1").range("a1") = "0" then msgbox "You're requested time has been entered for [date1] at 0:00 0:30." else: msgbox "Please enter a value into the specified cell." end if end sub Thanks for any help that is provide -- dok11 ----------------------------------------------------------------------- dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058 View this thread: http://www.excelforum.com/showthread.php?threadid=26186 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox Contents
HI try
msgbox "You're requested time has been entered for "& [date1] & " at 0:00 -0:30." Best N10 "dok112" wrote in message ... Hi, I have a messagebox, that contains certain information that changes based on what in input in a cell on the sheet. I have written the msgbox that i need, but the way i thought i could insert the cell contents didn't work. Can someone please help....I need the [date1] to show the contents of the specified range instead of "[date1]"..... Code: Sub Week1Sun() Dim date1 as variant [date1] = sheets("sheet1").range("c1") If sheets("sheet1").range("a1") = "0" then msgbox "You're requested time has been entered for [date1] at 0:00 - 0:30." else: msgbox "Please enter a value into the specified cell." end if end sub Thanks for any help that is provided -- dok112 ------------------------------------------------------------------------ dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581 View this thread: http://www.excelforum.com/showthread...hreadid=261862 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenate contents of cells whose contents resemble cell referem | Excel Worksheet Functions | |||
compare the contents of one range of cells with the contents of a. | Excel Discussion (Misc queries) | |||
Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
I want a msgbox when the contents of cell change | Excel Programming |