I don't know if this is possible. But I want to make multiple buttons on sheet1.
If you press one of these buttons it should open a form.
-- That part was easy --
Now I want to load the column value that is put in the button macros to this form.
so if button 1 has Column = 3 in it, then the form should take over this value to be used in the output when pressing a button in that form.
Form looks like this:
--- type here ---
So the form needs to know what button is pressed. Either by receiving a value (as an integer) or by "knowing what button activated him".
Thanks in advance