refEdit problem

Question

refEdit problem

Anonymous

i made a RefEdit in a UserForm.

i don't know why, once i press the refedit box, i cant do any thing else in the workbook, only select a cell (& the address enters in the ref-edit).

i tried to set the property of the form ShowModal to False, but didnt helped

i cant even Cancel the form, or the RefEdit box.

i cant even close excel.

if i try do do something else, there will be a noise.

once i select the refedit, the only way out is by restarting the computer.

please help me with it.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Answer 1

Re: RefEdit control problems

1. With Excel closed, delete all of the RefEdit.exd files on your system.

This is a file Excel uses as a map? to create the actual control.

If deleted it is recreated the next time the control is used.

Note1: there may be multiple instances of the file.

Note2: deleting all .Exd files on your system can't hurt.

2. Do not place the RefEdit control within a Frame on the UserForm.

3. If after trying the above and you are still having problems then see...

http://peltiertech.com/refedit-control-alternative/

'---

Jim Cone

Portland, Oregon USA

https://goo.gl/IUQUN2 (Dropbox)

(free & commercial excel add-ins & workbooks)

Share via

refEdit problem

1 answer