active x button

Hi all, I have countless option buttons in a sheet that are always grouped in pairs of two. The option buttons simply pass a value multiplied by the factor from A1 to another cell. Everything works like this... However, when I change the factor in A1, the corresponding value in E231 is not...

I hope there will be someone that can help with my question. I am trying to update the inventory of a specific product by using excel and the developer section commands. Thus I need t use a single button named as "add / subtract" in order to add or subtract a value of 1. I need to choose the...

I am a beginner at VBA and I've spent a lot of time trying to search for help on solving this issue I am having... I am trying to design a worksheet for users to complete. I have 10 cells B3:B13 where the user can write free text. There are cells D3:D13 which either display "1" or "0"...

I’m working on a VBA formula for a weekly schedule that will fill in cells with the current date and time when clicked. That part I have figured out with the formula below: Private Sub CommandButton3_Click() Sheets("Event Scheduler").Range("K20,K35,K50,K65").Value = NOW The Command...

I’m working on a VBA formula for a weekly schedule that will fill in cells with the current date and time when clicked. That part I have figured out with the formula below: Private Sub CommandButton3_Click() Sheets("Event Scheduler").Range("K20,K35,K50,K65").Value = NOW The Command...

Hello, I'm new here and I think this is a fantastic community. I need some help here since I'm very new to excel's developer option. I would like to know how I could use a command button to address a cell value into a Text box. I want the user to click on a button and update values in...

Here is the code I have for the Macro, but I am not able to figure out how to change the color of the botton on the worksheet. Can anyone help me fix my code. I am new to Excel: Sub Macro1() ' ' Macro1 Macro ' ' Application.ScreenUpdating = False Sheets("Template-Contact...

Hi Guys, I'm a new member, so apologies for any incorrect formatting! It's fairly easy (but I've never had to use Excel in this capacity!) I have a list of destinations set against each other with the distances of such in the corresponding cell, I'm trying to create an event to find...

Working in MS Excel 2010 I use the following VBA code to copy out a tab to a secondary file: “Workbooks([MainFile]).Sheets(Array("[TabName]")).Copy Before:=Workbooks([NewFile]).Sheets(1)” Note: This tab includes code and 3 (Active X) Buttons on the surface that call the code...

I am trying to apply a macros to an active x button. When checking the button, it should enter password to unprotect worksheet, it wll only show rows of all true statements retrieved from Column AL, when unchecked it should allow the user to view all rows regardless if AL column is true or...

I'm a newbie to VBA codes. I know I'm going to run into a lot of errors in this macros button. I can run the macros with no problem without it assigned to check boxes or buttons, but once I paste the macros in the code for an active x button; I run into errors. Please help. My code is shown...