Posted to microsoft.public.excel.programming

Jack Schitt Jack Schitt is offline

external usenet poster

Posts: 63

F2 + <enter without sendkeys?

Hi

Can someone please give me an elegant vba method of simulating F2 followed
by enter on a specified cell without using sendkeys?

The purpose is to convert a number stored as text back to a numerical value.

Any alternatives?

Thanks

--
Return email address is not as DEEP as it appears

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SendKeys problem	Rod Armour	Excel Programming	3	January 23rd 04 10:44 PM
Sendkeys	GB[_3_]	Excel Programming	0	September 16th 03 10:39 PM
SendKeys	Ron de Bruin	Excel Programming	3	August 25th 03 10:21 PM
SendKeys {Enter} acts like Return rather than Enter	Robert Chapman	Excel Programming	6	August 6th 03 06:51 PM
sendkeys	mark poole	Excel Programming	0	July 11th 03 03:47 PM

All times are GMT +1. The time now is 04:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us