View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default refilling data in same cell after user input in another cell

Right-click on the sheet tab and "View Code"

Copy/paste Topper's code into that sheet module.

Start pounding numbers into D2.

I strongly suggest you not use this method.

You have no way of correcting any errors made when entering a new number into
D2.

i.e. you have no "paper trail" to follow to see where an error occurred.


Gord Dibben MS Excel MVP


On Thu, 19 Apr 2007 12:54:02 -0700, H. Singh
wrote:

Thank You Topper -- But how I will implement this in an worksheet.
Can it be simple. Or Where I should start learnig how to use this visual
basic things without big hasstle in short time and without taking lot of
courses and spending lots of money.