Updating a Userform Real Time

What I am trying to discover is how to load a userform with worksheet data, update the worksheet via the userform and then have the new updated information show up in the userform for the user to see. The updating of the userform is the problem

Attached is an example of what I am doing.

Example AddSub RealTime Update.xlsm

As Always Thanks and Regards

Scott

Thank you for your response. I did as you suggested and changed the initialize sub to the arrays that you created. It appears to work well. Understanding what you did is a bit of a problem however. It would seem that arrays are going to be a particular nemesis of mine. I understand them… I can visualize them (at least to three dimensions) but for the life of me, I cannot determine when to use them nor do I seem to grasp the syntax. This could be a learning step forward but I request that you talk slowly and treat me like a child.

As for the second part; I created the command button and added your code.

I get a ‘sub or function not defined’ message and a halt on this line.

Please Login or Register  to view this content.

It struck me that ‘myarray’ should be defined at the top of the sub but I am not entirely certain how.
I added the line from the initialize sub:

Please Login or Register  to view this content.

And got a message of runtime error 13 – type mismatch
Debug halts on the line given above.

Please Login or Register  to view this content.

Regards
Scott

I must be missing something... and no doubt am. If you say it should work I take your word for it.

I started fresh using a copy of the worksheet I uploaded to this site... the copy you would have seen
Commented out my original code in the initalize and added yours copy and paste.
Addee a command button leaving its name default

Results are as I indicated previously
this time I added the Dim statement and code as you indicated ( I think I put it in the right place ) and the results are the same


Capture.PNG

Regards

Scott