I have a budget I am building where for example I have a cell that is labeled Groceries. I have a sum formula set up that I want when I click on that cell it will prompt me to enter new data that will be added to the total for that cell. How can this be accomplished?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sum formula requests data input
- Thread starter Dreddnews
- Start date
You can do it if you are sufficiently familiar with VBA, but it is rather involved.
You can create a user form and show it with the SelectionChange event for the specified cell. Then you can update the spreadsheet on a Click event for a button on the form and hide the form for next time.
A bit tricky, but it can be done.
You can create a user form and show it with the SelectionChange event for the specified cell. Then you can update the spreadsheet on a Click event for a button on the form and hide the form for next time.
A bit tricky, but it can be done.
- Status
Similar threads
- Locked
- Question