checked

Hello Everyone, I'm trying to extract some data from cell intersection by using index and match functions, I have checked a lot of video and checked alot of forum posts but i can't do it. I'll really appreciate your support. Target cell is shown below (Green Highlighted)...

Ok, I have super simple code and it refuses to work. I've used this code several times before on other workbooks and has done wonderfully. Sub Worksheet_Change(ByVal Target As Range) If Target.Address.Value = "$A$1" Then Call MyMacro End If End Sub Application.EnableEvents = True (I've triple...

I have a list of form control check boxes that I am using to change the color of another cell when the box is checked. What I would like to do is when the box is checked to uncheck the box when a reference or another cell is changed. Is this possible?

Hi All Have done a lot of searching and cant find an answer as to why my formula is returning #Value =SUMPRODUCT(--('1.RevenueRec'!$B$2:$C$10000=B$1),--('1.RevenueRec'!$A$2:$A$10000=$A3),'1.RevenueRec'!$I$2:$I$10000) I have checked and double checked column I in my data sheet, they are all...

Curious if this is possible: If you have a form that shows the fields for a records from a table, can you add a checkbox, either as part of the fields or separate, that when checked keeps the user from changing the data? I'm not necessarily wanting to "Lock" it as I am trying to keep it from...

Morning Guys, I have searched high and low for this and still unable to find the solution. I have an auto update (every 5 mins) on a worksheet with charts where it takes info from other worksheets and other workbooks, when all the charts are populated I don't get an error, but if 2 charts don't...

Hi Everyone, I have a set of checkboxes there names are CheckBox21 to 30 I just need a macro that if none of the boxes are checked I get a messagebox saying "please select one" how can I do this? Thanks Tony

Hello, I've been researching for a while but haven't been able to find an explanation. I know the issue is with the "not equal to" part but I don't know why. Why does the code updates the XYZ cell on column B when the cells on column C are "CHECKED" or "REVISED". The intention with the code is...

I have an excel file that has checkbox options on 1 of the tabs and I want to it to generate a summary on another tab that would only show those lines that correspond to the boxes that were checked, or it would only insert rows for lines that correspond to the boxes that were checked. Can you...

I have to pages of a MultiPage control on a UserForm that each contain 17 items, each comprised of a checkbox, label, and textbox. When a box is checked, a percentage is entered. Not all boxes will be checked. When this data is passed to the spreadsheet, I need all blanks to be 0 not "" in order...

Hello everyone, I hope you guys can help me with this problem i am having that I need a VBA solution to! i have 8 worksheets (worksheets 8-15) that I need to be copied over to workheet3 ("RevRel") the data in all 8 worksheets has the same amount of columns (A:O) starting from A1 but vary in...

Hi all, I'm chasing VBA to perform the following: I have a check box in Sheet1 A1, when checked I need the value of Sheet2 D4 shown in Sheet1 A2. Thanks in advance Mark

All I was able to find a good functional VBA code to place form data into a database(almost completed just need to add defects). See below. What I want to be able to do is instead of having a column for each of my defect families and types, I want a way to have the program review what is...

Hello,The following code generates a Run-time error (13) Type mismatch: Dim IloscWierszy As Long IloscWierszy = Application.VLookup(.Cells(i, 2).Value, _ "'[" & PlikBudżet.Name & "]" & PlikBudżet_arkusz.Name & "'!R" & WierszKosztyPensji_Budzet + 2 _ & "C" & OstKol_Budzet & ":R" &...

For some reason, my logo is getting slightly squashed when it is printed. It looks correct on the screen. I've got the logo in the header on the top right section, the "Scale with Document" box is unchecked, "Lock Aspect Ratio" box is checked, and "Relative to original picture size" is also...

Hi, I'm sure there is a simple solution, but I've been Googling this for almost an hour. I need a macro to unprotect, then re-protect, a worksheet. The following doesn't seem to work: Sub Unprotect () ActiveSheet.Unprotect Password: "my password typed here" End sub When I run the...

I wanted to check the s/no and date code from another workbook. I have the formula only check for S/No but not both. IF(ISNA(VLOOKUP(I8,[Warranty.xlsx]ADefect!$G$9:$G$100,1,FALSE)),"-","Yes") Where I8 the S/No to be checked in Warranty workbook from G9:G100. The date code in J8 to be checked...

I need to see if there is a way to this: Cell A1 I can enter a 4 digit number. Click a button to run a macro that will go to another sheet in my workbook, Look in Col G ( there are hundreds of numbers) and locate that certain number on the ROW and on that same ROW place and "X" in col M so it...

Greetings everyone, I have one final thing that I am trying to do on what will be a shared Excel file to prevent others from potentially changing or manipulating the information that is being entered. I have a list of requests that come through and each line gets a checkbox added. When this...

I have a user who recently had to have MS Office reinstalled. Since then, he cannot run macros in the workbook which he used daily up until the reinstall. If I unshare the workbook, then he can run everything as before. I have checked add-ins and macro settings, but am stumped otherwise. An...