Adapt Code for 1D Range Data Entry to Work With 2D Range

This code allows editing of cells via userform textboxes.
Class modules are used to transfer contents as you type.
Most has been developed by others.

A selection is made and the userform is populated when the macro is run. There is a differentiator ... the order of showing textboxes is by processing cells Down then Across, which is not the default, the default is Across then Down.
Up to this point, it works.

When it comes to editing the cell using a textbox, the wrong cell is changed (except for first and last cells). The link between the cell and textbox is still the default.

Please advise fix.


CLASS MODULE clsBoxes

Please Login or Register  to view this content.

CLASS MODULE clsDelegate

Please Login or Register  to view this content.

CLASS MODULE clsTyping

Please Login or Register  to view this content.

FORM CODE

Please Login or Register  to view this content.

Unfortunately, you have not addressed the query. Re-read post #2 in its entirety, particularly this:

Choose the cell first then the macro it works, chose the macro first then the cell it gets confused.

Does this cover the problems you are facing? Because, if not, you need to explain this in more explicit detail:

When it comes to editing the cell using a textbox, the wrong cell is changed (except for first and last cells).

In other words, give an example of what you are describing (wrong outcomes) and what you think the correct outcomes should be.

EDIT: I have just looked at your workbook and see now what you mean - it would have been useful to show the visual within your opening post!

Quick because I happen to be here - we are all volunteers doing this in our free time, remember.

I think, if I were you, I'd change the thread title to something like this: "Changing Default Direction in User Form from Across then Down to Down then Across". This might just pique some interest.

OK thanks, I am aware of the volunteer aspect.

It only changed the title in the last post. Can I start a new thread?

No - go back and edit the FIRST post - change the title there, please.

EDIT: I've done it for you.

By the way, are you really still using Excel 2007? If not, your forum profile needs updating, please.

Unfortunately I can't do this. How is it done?

On reflection I think that too much time has passed for you to be able to, which is why I did it for you.

Let us know how you get on with the suggestion in post #11 above.

Are you able to attach a workbook in which you have tried to implement it so that Torachan can check it for you? It may be that you have made a small mistake somewhere.

Can you answer Torachan's final question? Yes, he means the 2D range.

Agreed and done.