refedit control button missing

Chaitanya Lodha 1 Reputation point
2021-03-02T09:16:16.677+00:00

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

73307-image.png

73290-image.png

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nothing Left To Lose 396 Reputation points
    2021-03-02T22:42:07.83+00:00

    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

    0 comments