buttons & userforms - saving data?

Hello,

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)

If this isnt possible, is it possible to have a 'form' attached to a button that has some data that is entered and then stored?

im a beginner so im also looking to learn the code that makes this all work!

thanks!

well what i'd like to do is this:

Imagine a blank page with x no. of buttons. Each button you click opens up a form, and on that form there is data that is manually inputted by the user.

The next time the user clicks on the same button, up comes the form with the data that was inputted..

in my mind it must be possible but i cannot find the code or an example which is similar..

I dont really want to save the data to a another sheet, but if thats the only way to do it then ok..but i need the function when the buttons are clicked they call up the data that was originally assigned..

maybe a userform isnt the way to go about this?

"1. It's a waste of effort creating forms for each button
2. Any data has to be stored somewhere, it can't be retained by the userform normally

Attach an example workbook"

Hello,

Thanks but i disagree. As i mentioned i am a total beginner so im kind of looking for hints and tips, for the moment there is no spreadsheet in existance..i have just been playing about trying to understand how it all functions.

I thought if i created the macro i could then just draw a button as & when i wish and attach the macro - i dont see why that is a waste of effort. Anyway as for every button the information is going to be different it has to be done at one stage or another?!

The idea is to create a visual list of our wine. Thus every button represents a bottle with all the data about that wine.

When looking for wine to drink we can then just click on the buttons and up comes a window or form with the data. Also within the form or page or whatever we thought to have the date to drink by to help us organise the wine..

If userforms arent the way to go, what is the best way to approach this?

First of, I would never disagree with royUK. He knows more about Excel then you and I ever will know.

But maybe the attached is a starting point for you. You can enter all the wines available in Switzerland (and anywhere else for that matter) in it and make your pick.

If you were so inclined, you could even have a picture of the bottle appear in the userform.

Good Luck

HTH

John

thanks!

no doubt he knows alot about it, he just doesnt have a very good 'bedside manner'

no hard feelings though.

thanks for the sheet, i will play about & see what i can do!