Hugo huijer
Member
Hi Chandoo, first time poster here!
I need to learn basic VBA, and besides the nice introductions, it's really hard for me to follow. I consider myself to be an average Excel user, I know all the functions of Excel except for macros, which I'm just starting to learn. I am doing good on the really simple stuff, like recording simple macros, but when it gets beyond that point I'm stuck. I can't seem to get it right, as there are just so many ways of coding, and apparently i don't do it the right way..
Basically, I need my Excel file to do the following: (I'd really appreciate someone who can explain this to me, so I can then try to work with it myself)
I've got this sheet that needs to register data as inputted by a person. A person should just be able to click a button, on which a series of inputboxes appear, asking the user data (like data, numbers, info). This data will then be stored onto another sheet, in a registry. The registry will have a single column per input (inputbox), like a seperate column for data, numbers, info etc.)
When the user clicks the button again, the same series of inputboxes will appear. Only then the inputted data will be registered in the row below. Like this, a user can create an endless registry with rows of inputted data.
I can't get my head around this, and have not found a specific lesson that does this.
Can someone please help me? MUCH APPRECIATED!
Thanks a lot!
I need to learn basic VBA, and besides the nice introductions, it's really hard for me to follow. I consider myself to be an average Excel user, I know all the functions of Excel except for macros, which I'm just starting to learn. I am doing good on the really simple stuff, like recording simple macros, but when it gets beyond that point I'm stuck. I can't seem to get it right, as there are just so many ways of coding, and apparently i don't do it the right way..
Basically, I need my Excel file to do the following: (I'd really appreciate someone who can explain this to me, so I can then try to work with it myself)
I've got this sheet that needs to register data as inputted by a person. A person should just be able to click a button, on which a series of inputboxes appear, asking the user data (like data, numbers, info). This data will then be stored onto another sheet, in a registry. The registry will have a single column per input (inputbox), like a seperate column for data, numbers, info etc.)
When the user clicks the button again, the same series of inputboxes will appear. Only then the inputted data will be registered in the row below. Like this, a user can create an endless registry with rows of inputted data.
I can't get my head around this, and have not found a specific lesson that does this.
Can someone please help me? MUCH APPRECIATED!
Thanks a lot!
