Shift-Control Arrow and RefEdit Control?

A

Ariel

Does anyone know how to make the RefEdit allow a user to use the shift-control and arrow keys to highlight the range (as can be done by the built-in Excel EditBox)

Please email me with the response to [email protected]

Thanks in Advance!
 
R

Rob van Gelder

Ariel,

It works if you make the userform modeless.
Unfortunately, Excel hangs when you mix RefEdit with a modeless userform.

I don't think there is a simple way.

Rob


Ariel said:
Does anyone know how to make the RefEdit allow a user to use the
Click to expand...
shift-control and arrow keys to highlight the range (as can be done by the
built-in Excel EditBox)?
 
A

Ariel Linden

Thanks Rob. Should I even bother reconfiguring the userformto become
Modeless? Or should I give up on the idea altogether?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
D

Dave Peterson

Maybe you can turn on screenupdating and use

dim myRng as range
on error resume next
set myrng = application.inputbox(Prompt:="select a range",type:=8)
on error goto 0
if myrng is nothing then
'do whatever you want...
else
'do whatever you want here, too...
end if
 
A

Ariel Linden

Dave, the inputbox is a good idea, but it is a stand-alone application.
I need something that will work from within a userform.

Any ideas?


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
D

Dave Peterson

Put a button on the form that says: Select The Range
have the button hide the userform and popup the inputbox????
then unhide the userform when the user is done.
 
J

Jim Cone

Ariel,

Install the XL2000 hotfix from the following MSKB article.
Contrary to what the article says, service packs do not fix the issue.
This also applies to XL2002.

http://support.microsoft.com/?kbid=291110
XL2000: Cannot Use Keyboard Shortcuts to Select Ranges in RefEdit Control

Regards,
Jim Cone
San Francisco, CA

Ariel said:
Does anyone know how to make the RefEdit allow a user to use the
Click to expand...
shift-control and arrow keys to highlight the range (as can be done by the
built-in Excel EditBox)?
 
A

Ariel Linden

Hi Jim,

Thanks for steering me to those updates. Do I need to install all three
service packs to get this thing fixed?

Ariel

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
J

Jim Cone

Ariel,

Generally speaking, you should always install the MS office service packs.

However, the issue with the RefEdit control is not fixed in XL2000 by
installing the service packs (according to correspondence I have received).
Also, in my case, the RefEdit issue was not fixed in XL2002 by installing
the service packs (even though it is included in the list of fixes for
XL2002).

The mskb article tells you about a registry edit to cure the problem.
Review that again and follow the directions or get someone else who is
familiar with editing the registry to do it for you. (However, I would
install the service packs first.)

Regards,
Jim Cone
San Francisco, CA
 
A

Ariel Linden

Thanks Jim,

I am downloading the packs now, and I will work the registry thing..

Thanks again for your help..

Ariel

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Top