question

ChaitanyaLodha-8707 avatar image
0 Votes"
ChaitanyaLodha-8707 asked ·

refedit control button missing


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


office-vba-dev
image.png (28.9 KiB)
image.png (5.2 KiB)
· 1
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Viorel-1 avatar image Viorel-1 ·

Maybe make sure that RefEdit.Ctrl is also selected in Tools, Additional Controls dialog of Visual Basic.

0 Votes 0 ·

1 Answer

NothingLeftToLose-5122 avatar image
0 Votes"
NothingLeftToLose-5122 answered ·

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

·
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.