checkbox1.value

I have code that puts data into columns depending on weather or not the check box is checked. I also have code that checks the value of the cell and re-checks the box if >0 I Can't seem to get both codes to work, whichever on I have first works but the other doesn't. If I switch the order then...

Hello, Im still very new to excel and been testing alot of diffrent stuff. But right now ive been thinking about this simple little vba-code Private Sub CheckBox1_Click() If CheckBox1.Value = True Then Columns("fj:fs").Hidden = False End If If CheckBox1.Value = False Then...

Hello peeps, I need some help here. When the COMMS & GO box are checked, and I click on Generate Form, it will move to the "COMMSGO" Sheet. I manage to do until here. But however, I just it to show only the "COMMSGO" sheet and the rest hidden. Same goes if i do it for other sheets. How do I...

Hi All, I am new to VBA coding and I have the following query: Background of what I want to achieve: I have two tabs in this example. The first tab is called "Summary". The name for the second tab various based on the value included in cell B2 of that worksheet which is determined by a...

I have a command button and amongst the code is this; If Range("AM4").Value = "ASH" Then CheckBox1.Value = True End If However, when run the command button, I get an error on the above code and cannot work out where I'm going wrong! Any help would be appreciated. Thank you