I have an excel sheet with some buttons on it.
These buttons just do a simple task. When you click on button 1 a value of a cel is counted +1 and when you click on button 2, this value is counted -1, nothing can go wrong....
But now I want a userform that is opened when I click button 1, and in this userform, the user sees the question "why he/she pressed the button" and the user can typ in a comment. This comment is then used to display next to the cell where the value is changed.
I'm looking through a lot of forums and see many codes that can do all kind of things, but just not the simple task that I need.
I know how to open a userform after clicking the button but I need some help 'building' the userform itself.
How do I need to make a code that asks the user for input and then use this input again on the main sheet.....
Hopefully I explained good enough what I need and is there somebody who can help me..
Bookmarks