Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
Topic starter
Im trying to create a spreadsheet consisting of buttons and userforms 'behind' each button.
I have the button and the userform and both work, but it doesnt save the info - is this possible to do? (ie, everytime you click on the button the same data appears once entered)
also, is there any good site for learning the basics about vba and the code necessary to do what?
thanks!
Posted : 23/04/2010 5:52 pm
MrExcel is quite good
Posted : 24/04/2010 2:27 pm
yes possible, you need to define variables on the user form then set the cell value to the variable.
worksheet("....").range("....").value = x, that sort of thing,
Posted : 24/04/2010 4:19 pm