Dependant Text in a MsgBox

**bowhunt24** · 11-17-2011, 04:32 PM

How do I make the message that appears at the conclusion of a macro display a value that is sourced from another list. For example, you can use a drop down list to select your location. The Macro copies the value to several places around the workbook and then pops up a message that says "You changed your location". I would love it to say "You changed your location to 'VALUE'" where as "value" would be the location you selected.

Any way to do this? I imagine it is something along the lines of:

MsgBox "You changed your location to 'A1'"

Or something like that....

**davegugg** · 11-17-2011, 04:37 PM

msgbox "You changed your location to '" & combobox1.Value & "'",vbokonly

**bowhunt24** · 11-17-2011, 04:51 PM

Thanks for the quick reply! Ummm....apparently I'm not as smart as I though...How do I modify the code you so generously shared to make it work. The cell that contains the value I want displayed is "J1".

So would that make it look like this?:

msgbox "You changed your location to '" & combobox1.J1 & "'",vbokonly

**davegugg** · 11-17-2011, 04:53 PM

msgbox "You changed your location to '" & cells(1,"J").value & "'",vbokonly

**bowhunt24** · 11-17-2011, 04:57 PM

Genius, thank you sir!

**royUK** · 11-18-2011, 02:15 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save