Really Green Question using VB code to make a button to run a formula in excel.
Hi,
I haven't used Visual Basic since Highschool so I am very very rusty with it. I've applied for a job where the main focus of the job isn't programming but there is "small amounts of basic programming required." I know I can get back into the swing of things with some time but I don't really know where to start.
I've sent them a spread sheet I've made at my current job to make my job easier and they said it was ok but they wanted to see an example of it with some VBA code in it. I figure the best way to do that would be to have 6 buttons at the bottom and you could click each button and it would display the changes needed to the current asset mix to to line it up with the investor type selected with the button (rather than using the drop down box in the first example). I know the formulas I would use to do that but I don't really know how to start programing the buttons to make them run the formula in excel. I've attached both of the sheets if you would like to take a look at them.
If you can give me a nudge as far as what kind of code I need to use to run a formula or if you can recommend a good beginner tutorial for coding in VB I would really appreciate it.
Reply With Quote