Skip to Content

VBA code - layout change

Nov 30, 2017 at 02:11 PM


avatar image
Former Member

Hi, I have simply line in my VBA to set focus on field, but sometimes it doesnt work:


I found its most propably becouse two reasons:

1) layout change. I tried to switch columns and then I recorded but different code:


2) field is not on the user visible screen (its outside, but if you will scroll to to left you can see it)

Its possible to change command to ignore those two points, so focus will be there no matter user change layout?

For example something like this?


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers