Hi all,
I'm new to VBA and activex controls in excel. I've figured out how to create macros and assign then to buttons but now I need to create a simple user input on my spreadsheet.
I have cells A1 to T1 containing the numbers 1 to 20. These numbers represent years. On a seperate worksheet I would like the user to be able to enter a cost and select a year, then click a button that inputs that cost into the cell directly underneath the year they selected. So it looks a little something like this:
Cost: *The user enters the cost here*
Year: *The user selects a year from the drop down list (1-20)*
ADD - *the user clicks the add button and the cost is inputted into a cell directly below the year they selected (on the other worksheet) - and maybe some sort of confirmation to state it has worked*
Any help would be greatly appreciated. Many thanks.
Adam
Bookmarks