Hello,

First off, I'm fairly new to actually using VBA so this might be a totally stupid and easy question for the more experienced user, but you got to start somewhere. I'm building a userform to allow people to enter information and automatically populate an excel document. I've been getting along with it pretty well and have learnt alot, I can get the information entered to populate on the form, automatically enter the user's name that has opened the form, added some como boxes etc with dropdowns but I just cannot for the life of me figure out how to get excel to do this....

I have a number of textboxes, named textbox1, textbox2 etc. I would like people to enter numbers etc 2,4,4 and for a running total to appear in textboxt4 for example. I've looked online and have seen various solutions but the classic copy and paste, look at the code and figure out what's going on has left me very confused. I cannot believe its that hard to do via VBA.

If anyone can give me a heads up to what the code should look like that would be gratefully appreciated. Please don't make me feel too stupid. I bet when its so obvious!!

Daniel