Hi Again,
I want excel to bring up a message box, that repeats a value in a set cell, for example 'P3', i am familiar with message boxes bringing up text and input options that have been pre-defined, but im unsure on how to get it to display text in P3, mainly as it will change so much, any thoughts please?
galvinpaddy
Last edited by galvinpaddy; 11-22-2011 at 10:16 AM.
Hi galvinpaddy,
Put some text in P3 and then run this code:
Sub DispMsg() MsgBox ("This will Display " & Cells(3, "P").Text) End Sub
One test is worth a thousand opinions.
Click the * below to say thanks.
OK, thanks for that, next would be, where do i fit that code into the following?
I woul dneed it to go after the 1st msg box, but before the second part of coding.
Thanks in advance.Sub Macro6() ' ' Macro6 Macro ' ' Range("G3").Select Selection.Copy Range("I1").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False If Range("M1").Value = "1" Then MsgBox "You have already clocked out!!!" & vbNewLine & "Please delete Entry" End If Range("M1").Select If Range("M1") > "0" Then Range("H3").Select Exit Sub
I can't tell what you are trying to do with the second message box to be able to say.
I think you want to use the single line of:
in your code only.MsgBox ("This will Display " & Cells(3, "P").Text)
Maybe a better discription of what you are trying to accomplish or a sample workbook would help me understand what you want.
One test is worth a thousand opinions.
thanks very much fella!! that works spot on.
Apologies for the poor explanation, i have a 7wk old daughter who thinks its fun to scream all night
Thanks again!!
galvinpaddy
please mark as solved
Thankyou
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks