Hello all and greetings,
I am experiencing something strange. I have an excel program/macro that allows someone to define a system. (I do some things with system modelling and am using excel to define the systems).
A user can configure various application components. Each of these components has a row with a delete button, a position change button, a name button and a mapping button.
Below the lowest row, I have made an add button that allows a user to add new rows.
ApSj0Bn.png
When this button is clicked for the first time, this happens:
cjhp6Yk.png
What should happens is that I should get an extra row and the addbutton is moved down 1 row. I coded this to delete the addbutton, and add a new row and a new addbutton on the correct position.
However, when I now move the userform screen a little using the mouse, poof! Everything is ok. Also, if I move the userform before clicking the addbutton, there is also no problem. I tried using solutions with Repaint or Screenupdating, so for as to no avail.
All buttons and events have been coded dynamically.
In my code, an event listener is running in the background, I adapted that from this forum:
http://www.mrexcel.com/forum/excel-q...control-6.html
I would be happy to provide more information (code etc), if deemed necessary, but first I was curious if someone has seen this behaviour before and maybe can give me a straightaway answer!
Thanks in advance!
Note: I expected the images to be shown directly in the post, but I see there are only links. I hope they works.
Edit: A sample file can be found here: https://dl.dropboxusercontent.com/u/...013_06_05.xlsm
Is there no way to upload it to this site? I could not find the option...
Bookmarks