check

Bear with me as this is not my forte with Excel! I am composing a simple excel sheet for users to complete, I have started using check boxes but what I need is if a user ticks a box, they have to select an option from a list, and the response is populated in a cell somewhere. I know how to use...

Hi Everyone, I need a macro that when it runs will check the text in a standard shape textbox called "Words 1" please help if you know how to do this, thanks Tony

Hi, I need to transform a raw extract into a new sheet for a pivot source. The raw extract has transactional information + check-in and check-out as shown below: <colgroup><col><col span="2"><col><col><col><col></colgroup><tbody> LISTING'S NICKNAME CHECK OUT CHECK IN SOURCE ΣTOTAL PAYOUT...

Hi. Is there a good way to make it so that if i click a button, the code will check if a spesific cell has had any values in the last 10 times (10 is just an example), and if it hasent, a error message /msgbox will appear? Example. Lets say A1 is the cell i want to check, and a button with...

Hello I have made an example of my problem below where I want to match data/ get to know if it exist in a group, separated by an empty cell. All "groups" are put in the same row and have a header. How can this be done by formulas? How can I confirm if Header1 has cat? How can I confirm if...

How to write a VBA code to get the below output. If Column A = Internal, Then column F = ok and If Column C = Long or Short Then column F = ok and if Column A is anything else, then it should check if Column C = Long or Short if yes then column F = ok else column F = check. Thank you in...

I have dates in A6:A41. In column B6:B41 I have some check marks. I am trying to find the days between the last two check marks in column B. There will be blank cells between the check marks. I have googled and googled and can't come up with an answer any where. You have been a big help in...

The link below shows various ways to detect internet connection. Sometimes you have a requirement to enter a user name and password to access the Internet, how do I check if I'm fully connected to the Internet...

Hi everyone! Im new to the forum and macros. have been using excel for a long time but very basic stuff. decided to dive deeper and gave myself a mini project. the first step of the project, is to check whether a range in sheet 1 has any value, if true, then copy the range into sheet 2, else...

Hi, I have multiple workbooks and would like to check that what the scaling is on each of the tabs before I print it out. Maybe some script that gives me a report tab maybe. Thanks Rich

Hi All I have a Office 365 spreadsheet with 23 check boxes for categories for sweets (the check boxes either hide or show a row in another sheet). I also want to add a couple of check Boxes that will select all the "chocolate" (checkbox 24) sweets and deselect the remainder or select all the...

I have a workbook with VBA that was made years ago with Excel 2003. (see VBA below) The sheets have many cells throughout that I can "Check off" with a click, to put an "X" in the cell. (Each column has a hidden column next to it and when there is a "q" in it, the cell to the right will put...

Hello, I need to find a formula that will compare data across 1 column in 1 worksheet with 1 column in another worksheet and report back on whether the data appears in both columns or not. Example scenario: A customer sends across a list of product codes they would like us to quote, i have...

Hi I want to insert a formula in the cell left to a check box, if the CheckBoxes.Value = xlOn : Sub test() For i = 53 To 102 If ActiveSheet.CheckBoxes(i).Value = xlOn Then ActiveSheet.CheckBoxes(i).TopLeftCell.Offset(1, 0).Formula = ("=2+2") End If...

Hi there, I am trying to identify a mismatch based on non-numeric data in a spreadsheet but unable to do this without a helper column that converts it to a numerical value. It seems like there should be an easier way to achieve this (without the helper column) but I gave up searching for it...

I'm using MKDir to create a file in a folder. When creating a file, the file name is saved with a random generated 16-digits Alpha-Numeric (i.e. DS1O-Q7LN-X7MP-EJA8) name. The code below checks for a specific file, however How can i check if there is a 16-digits Alpha-Numeric file exist...

Hi there, I am making a userform. I have to checkboxes, checkbox1 and checkbox2. I want to make it such that user can only check one of them at tiime. And I also want to make it as mandatory question for the user such that he or she needs to tick one of the checkboxes! thanks for your help

I am looking for a way to check if the user has selected a single cell or single row within a Listobject. If this is the case, then I would like to return the value from Column 1 of the Listobject for the particular row. Not sure how to start with this one. any help is much appreciated. many...

I have created a formula dealing with TIME =IF(B7="","",TEXT(D7-B7,"h:mm")-C7) The formula works fine but the cell shows an unexpected "green" check mark. It not part of the returned value, it's just there. Any ideas of how to get it gone?

Hi, I am looking for a way to verify if a cell say A1 contains same digits like 1111, 2222, etc. The Len will always be 4. Thanks in advance