refedit control button missing

Question

I am looking to add a control which can take a range as input. I found out that refedit control allows to do exactly theat. However the refedit control button used in Excel VBA Forms is missing. I have turned on the Ref edit control from the preferences but its not showing up in the toolbox. not getting any error or anything. any help will be appreciated. I have excel 365 on windows 10

Answer 1

Re: "control which can take a range as input"

The Application.InputBox can also do that.

Note1: there is also a vba.InputBox which accepts text as input.
Note2: The RefEdit control has some problems, which seem to pop up unexpectedly.

For what it is worth, I don't use the RefEdit control anymore.

'---
NLtL
https://1drv.ms/u/s!Au8Lyt79SOuhZ_2VvKCLZxz9iwI?e=vnEabM
Free: Add_Table of Contents, Calculate Payments, Custom_Functions, Professional_Compare, USA Lottery Numbers

Answer 2

In Excel go to File->Options->Trust Center->Trust Center Settings->ActiveX Settings and change from disable all controls to any of the other options. Microsoft has changed this setting in new Office installations and via Office update to disable all. But they forgot that refedit controls are used by many many macros..... It would have been nice if they first offered a control that worked with ActiveX disabled before disabling.