ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Change cell with command button (https://www.excelbanter.com/excel-programming/429083-change-cell-command-button.html)

AJ

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