how do you reference cells in a popup box? i want a box to come up at the end of a macro and have cell values referenced in it. thanks for the help.
Pop Up Box
-
-
-
-
Re: Pop Up Box
i cant seem to get your suggestion to return more then one cell. i would like to return h2:n12. and for total kicks be able to print this. thanks
-
Re: Pop Up Box
Is this what you mean
Code
Display MoreSub Input_Range() Dim oRange As Range On Error Resume Next Set oRange = Application.InputBox("Please select a range of cells!", _ "Select Range", Selection.Address, , , , , 8) If oRange Is Nothing Then MsgBox "You cancelled the operation!" Else MsgBox "You selected: " & oRange.Address(external:=True) End If End Sub
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!