RefEdit - As an input box, not on a user form?

[Rusty]

Question about the refrence edit box / control.

I'm aware that it's available for user forms, but is there the same functionality as just a user box? (eg, like a MsgBox or InputBox) that can be launched from a macro with out the need for a form.

 

[erik.van.geit]

Yes,
see the helpfiles for inputbox
use Type:=8

Sub test()
Dim RNG As Range

Set RNG = Nothing
  Do
    On Error Resume Next
    Set RNG = Application.InputBox(prompt:="Select your range", _
    Title:="SELECTION", Default:=Selection.Address, Type:=8)
    On Error GoTo 0
    If RNG Is Nothing Then MsgBox "please choose range and press OK", 48, "ERROR"
  Loop While RNG Is Nothing

End Sub

kind regards,
Erik

 

[Rusty]

Thank you so much.

For the code / mini app that I am doing, a user form will be better as I also want to provide an a/b option to determine what to do.

But the knowledge will be very useful in the future.

Thanks again.