Change cell with command button
I have a sheet in a workbook that is an array of information
column1 column2 column3 column4 product1 blue round 1 product2 red square 3 On another sheet I have a combobox to list what is in column1, then I have it linked to another cell. Still on this sheet I have cells that lookup column1 and pull from the other columns. When the Product is selected I add 1 to column4 on this sheet. say I pull Product2 then my sheet looks like this: Product: PRODUCT2 Color: RED Shape: SQUARE number: 4 What I need to do after this is create a button that when clicked will then change the value in column 4 to 4. This way the next time Product2 is selected it will be 5. Is this possible? What code would do that? Thanks in advance for all help. -- AJ |
All times are GMT +1. The time now is 05:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com