change value

Hi all, I have a sheet with numerous Activex optionbuttons. I have a reset macro which would put the value of each button to false, this used to work fine but I added a new optionbutton (no big deal I thought) but now the macro runs but doesn't change the value, the code is below and any help...

Hello, Thanks in advance for your help. Every time cell J10 changes value and is greater than 0, I would like an email to be sent via outlook. Recipients are in cell E2, Subject is in cell E3, and the body of the email is a chart (to be pasted as a picture) in cells D8:H18. The value in...

Hi All, been a while since I've posted here managed to avoid excel and all forms of IT for the past 5 years (it's been blissful :rofl:) however here I am at a desk staring at many many spreadsheets. I am trying to create a downtime log of sorts, what I am trying to achieve is when the user...

Hello all, I have searched an answer for my question but couldn't find one. Please excuse me if there was a similar one. Right now my excel file can create PDF and send e-mails thanks to Ron de Bruin's add-in. What I do is, I change the value of one specific cell manually which updates the...

Need VBA code to start with row 5 and look through COL F for any blue cells, IF=BLUE change the percent to 0% for that cell. The RGB color code for this particular shade of blue is: Red 153, Green 204, Blue 255.

I have a spreadsheet with thousands of records relating to samples at water monitoring stations. Each sample is from a specific station of which there are over 1000. Each relates to a sample, so station IDs are repeated many times in rows. I need to run a macro that will use the forecast...

Hi Folks, Can not find a post for this; I need a macro to to change a cell value from false to true or from 0 to 1. I have a number of cells I want to be able to just click or double click the cells and change it back and forth as needed. I tried the check boxes for this but they do not...

I have formulas in my speadsheet that I cannot protect due to the fact that the user will need to change the cell from time to time. I would like a msgbox to appear everytime they try to change the value of a cell, stating "Are you sure you want to change the value of this cell?", if user...