I have never written or used a macro before and I have a simple macro task to complete:


I have Column L (L4:L10) of seven scroll bars that move according to number changes in column F (F4:F10). I want to create a form control command button that resets the changes on the scroll bars according to static column of numbers in Column E (E4:E10).


I don’t know if it matters, but I’ll add that I plan to add a second button that does the same thing with a different column of data. I assume I’ll simply replicate whatever procedure I use in the first button—is this okay?


This is quite simple, right? Can anybody help me or point me in the right direction? I have no experience writing code or macros. Thank you.