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.
|