Here, give this a try.It was a simple matter to have it select the text box
after completing.
The other problem was because basically, there are 16,384 columns in each
row.When you add or delete the row, you're "changing" 16,384 cells.
so, the macro is running 16,384 times!
I added a line in whic
Respected Mr. Paul
your idea of creating text box is really very nice .. But when i started
using this i found two issues
1] When ever i change any cell -- crusor should automatically goes to that
box only & not as normal
as next cell or down ...
2] If i delete any raw or insert any raw then
Thank you very much for explaining in details.
God Bless you & all members of our wonderful groups.
Excel can do so much wonders that we can not have think it before.
On 3 March 2016 at 19:10, Paul Schreiner wrote:
> I can make the changes, but you will still need to rely on others to make
> c
I can make the changes, but you will still need to rely on others to make
changes!
I'll try to explain:
Macros have "scope":That is: Macros (Subroutine or Function) are stored in VBA
"Modules"There are several types of Modules.The most common are "Sheet"
modules, "Standard" modules and "Form" mo
Respected All
Last time some brothers have help to make this file perfect
I want some clarification / suggestion on this file
I have approx more than 1000 entries to do in this file
1]When I start inserting lines & copy past
