Cant Seem To Deselct RefEdit Box On Userform

Hi Forum,

I have several ReEdit Boxs on a userform and when i click on one and select the range i cannot seem to deselect the RefEdit box and move on to the next one. All i can do is keep selecting a new range in the same Refbox.

Any help would be much appriciated.

Thanks

Good afternoon JR@SGC

Is your RefEdit box in a frame (or anything else for that matter)? If this is the case, take them out of the frame, and they'll work perfectly.

RefEdit boxes dislike being contained in any other type of control and will work intermittently if they are.

HTH

DominicB

Hi dominicb


I have them in frames and checked the properties of the frames which were all fine (they seem to like the frames), but then i checked the showmodal property of the userform and found i had it switched to false.
It turns out that they did not like this very much and threw a little tantrum untill i switched it back to true.

I will however, check if they work with the show modal on false outside of the frames as you suggested as this would suit my needs better.


Many thanks for your help, oh and nice addin.

Hi JR@SGC

Many thanks for your help

You're welcome.

oh and nice addin

Thank you.

DominicB