ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Controls in Excel (https://www.excelbanter.com/excel-programming/300475-controls-excel.html)

esr

Controls in Excel
 
I need to create a form-like in Excel that allows me to input amounts that will go to update another worksheet.
I got so far, a Combo box that brings up the corresponding record: Name, Amount, etc. This Combo Box works with a defined Name Range that covers enough to do this.
Now, I need to be a able to change some of those values in a particular record, so the display reflects those changes too. How can I link the other control - say, a List Box- and be able to input new values
Thank u for any help!


All times are GMT +1. The time now is 03:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com