| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change from a Command Button to a Form Button | Excel Programming | |||
| Change text in a cell from a command button on a Userform | Excel Programming | |||
| Change Name of Command Button | Excel Discussion (Misc queries) | |||
| Change active cell properties with command button | Excel Programming | |||
| Change active cell properties with command button | Excel Programming | |||
Linear Mode
