Wrox Programmer Forums
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 5th, 2005, 06:20 AM
Authorized User
 
Join Date: Nov 2005
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default Formula in Excel

hello,

  I am using Microsoft Access, and trying to creating one FORM, now what i want to do is, when i suppose to enter data in row, after pressing TAB (to move next column), the entered data shoudl multilplied by 0.001 and replace there itself when i first enter data..

  Any ideas, tell me in brief, am new to EXCEL..

~ ~ ~ There is no Right, There is no Wrong, KNOWLEDGE is Only the POWER ~ ~ ~

~ ~ ~ There is no Right, There is no Wrong, KNOWLEDGE is Only the POWER ~ ~ ~
__________________
~ ~ ~ There is no Right, There is no Wrong, KNOWLEDGE is Only the POWER ~ ~ ~
 
Old December 5th, 2005, 06:51 AM
Authorized User
 
Join Date: Oct 2004
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to shattered Send a message via Yahoo to shattered
Default

If I understand the question correctly...

Put this in the worksheet..

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Application.OnKey "{TAB}", "IncrementNum"
End Sub

And this in a module..

Public Sub IncrementNum()
    myRow = ActiveCell.Row
    myCol = ActiveCell.Column
    If myCol = 1 Then Exit Sub
    Cells(myRow, myCol).Value = Cells(myRow, myCol).Value * 0.001
    Cells(myRow, myCol + 1).Select
End Sub






Similar Threads
Thread Thread Starter Forum Replies Last Post
Putting Formula in Excel Sheet ritesh2381 ASP.NET 1.0 and 1.1 Basics 0 March 26th, 2008 05:59 AM
Excel to Javascript formula assistance recei Javascript How-To 1 February 6th, 2007 10:25 AM
Excel Formula zachtom Excel VBA 4 May 6th, 2006 08:02 PM
converting formula in excel ct Excel VBA 0 October 5th, 2005 10:06 PM
What does it means in a EXCEL formula?! aarias Excel VBA 1 October 2nd, 2003 02:56 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.