Dynamic dialogBox update

[blaksnm]

Hi
I have some instructions as text in Range("Instructions1") and Range("Instructions2")
I want this to appear as one interactive messagebox when starting the excel-file (auto_open) so I can give new input in the msgbox who updates the ranges when macro proceeds (by "ok" or something like that)
How do I do this?
Will anyone guide me on this?

 

[blaksnm]

Is the named range OppgaverFaste a single cell?

No - its a range c55:c59

 

[Saurabhj]

And that's why you are getting error. Do you need concatenated string in message box?

 

[blaksnm]

TYhanks
I have to think again

 

[blaksnm]

I am approaching something here
I could ask for more help though:

Here is my modyfied macro (ignore the Norwegian language - its not relevant):

Sub Test()
Dim response1
response = MsgBox("" & Sheets("test").Range("a1"), vbYesNo + vbQuestion, "Endre faste oppgaver?")

If response1 = vbYes Then
newmsg = InputBox("Enter new message for instruction 1")
Sheets("test").Range("a1") = newmsg
End If

Dim response2
response = MsgBox("" & Sheets("test").Range("a2"), vbYesNo + vbQuestion, "Endre variable oppgaver")
If response1 = vbYes Then
newmsg = InputBox("Enter new message for instruction 1")
Sheets("test").Range("a2") = newmsg
End If
End Sub

Question1: I want to edit in msgbox emidiatly - with lines as in dump1
Question2: If not possible I dont' want to delete the existing data - just edit them (dump2)

Mark1: This popup msg will be a reminder when opening the file
Mark2: What is the best way to make it easy to write an new line?

 

[diddi]

you might be able to join the lines together using range("C55") & chr(13) & range("C56") & ... etc
chr(13) represents the line return so you will get your 4 line of instructions in the message box

 

[blaksnm]

Aha ... will look into this
Thanks