F2 + <enter> without sendkeys?

J

Jack Schitt

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
 
J

Jack Schitt

Thanks that is just what I wanted

Beto said:
value.

Instead of that you could use this:

Sub Text2Number()
ActiveCell.Value = ActiveCell.Value
End Sub

Regards,
Click to expand...
 
B

Beto

Jack said:
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.
Click to expand...

Instead of that you could use this:

Sub Text2Number()
ActiveCell.Value = ActiveCell.Value
End Sub

Regards,
 
Top