checklist

  1. R

    Excel question

    My question is How to create a check list within a check list - so basically if i have: Required deliverables Complete? Business Case Project Risk Analysis Project Charter Project Considerations Project Management Approach So if they say Business case complete Yes- then...
  2. W

    Updating table data from Checklist

    I have a table with world wide location data where each row includes the location's continent, approx 4,500 rows. I have a macro that runs a query on all the data but would like to include a checklist which would restrict the query to selected continents. I've set up a Form Control checklist but...
  3. schielrn

    Form for Checklist

    I am struggling figuring this out and thought it should be something simple. What I want to do is create a subform in a main form that is a checklist that needs to be marked as pass, fail or n/a. I have a table that based on the product they select will show the appropriate checklist items...
  4. N

    Checklist formula

    Hi, I am working on our checklist. The current setup is that, when cell in column D is double clicked 1. It will show a check mark 2. Cell in Column E will be updated with the time when the cell was double-clicked 3. Cell in Column F will be updated with the person's UserID The issue that I...
  5. P

    Excel checklist with buttons

    I currently have workers filling in paper check sheets for their vehicles which i can only get hold of at the end of each week, this puts me behind and has poor visibility on paperwork completion. I am trying to put together a data sheet each person could fill in. This needs a drop down menu...
  6. J

    trying to make a checklist smarter

    I have 2 work sheets "Main" and "CheckList". The "Main" work sheet has selections in cells B14:B29 and in cells E14:E21 (by selections i mean i have made is so that when these cells are activated they auto fill with an X) I also have a button on the page labeled "Print" The "CheckList" page...
  7. P

    Sub is triggering Selection Change Sub

    When I step through this sub, all of a sudden now it is triggering the Selection Change Sub I just made. This code was working fine. Now its not working and when I try to debug I see it jumping over to the Selection_Change Sub. Anybody know why it keeps jumping over to that Sub? Headscratcher...
  8. R

    Using a "Period" as a separator for a checklist item

    All, I've search long and hard and just have not bee able to find a solution to solve my issue. I am using Excel to create a checklist within a multi column table. I want the checklist to look uniform and i'm having trouble doing this systemically. Here is an Example: Item #1.........Check...
  9. J

    vba nested if

    Hi, I would like to make code that if column B and A values are in the CheckList sheet, Column C,D,E values must be in CheckList sheet. However validating Column B and A works good, but C, D, E are not working correctly. Does anyone have any idea on this? Dim ValidateL As Long: ValidateL =...
  10. A

    List of Open Items

    Hello all, I have an excel file that is a collection of checklists as well as a summary page on the first tab. Each checklist is written in it's own worksheet tab. I want to put a command button on each checklist that, once clicked, will put the name of the checklist on a "list of open...
  11. A

    If cell value = C then current time in another cell.

    Hello, I'm trying to create a checklist. There is a drop down menu on one end of the checklist that allows you to choose "C" to mark a particular item complete. I want the spread sheet to log the time each individual checklist item is complete. Currently I have in the cell that needs to show...
  12. M

    PowerPoint Checklist

    Hello, I was wondering if it was possible to create a checklist next to a PowerPoint slide; not a checklist slide. For instance, a slide will have a header, some text and a picture. I was curious to know if I can have a pop-up form or something in the slide with a checklist for us to ensure...
  13. F

    passing a ParamArray to another sub that accepts a ParamArray

    I have a number of subroutines that accept a ParamArray for an indeterminate number of parameters, viz: Sub CheckList(ParamArray vList()) ' ' checks stuff ' End Sub Sub PrintList(sMessage as String, ParamArray vList()) ' ' prints stuff ' CheckList vList CheckList vList() CheckList...
  14. J

    activeX multiselect list doesn't save when exiting

    I have created a small macro to display a checklist that can by checked off and says "Complete" once all items have been checked. I created this using ActiveX Listbox with multiselect. However, when the file is saved and reopened, all the check marks clear out. Is there a way to fix this so...
  15. S

    Help Filtering Columns with checklist

    Hi, I'm trying to create a spreadsheet that allows me to filter columns (hide/show) them according to a checklist. It is for use as a line-list pro forma for Music shows. So across Row C I have various instruments listed from C3 to CA3. I want to be able to check these on/off in some way so...
  16. P

    how do I make a protected checklist?

    Hello, I would like to make a shareable workbook that will only allow cells to be colored in or checked off, is this possibly, kind of like a checklist. I don't want anything else changeable. Thank you for your help
  17. muhammad susanto

    Conditional Formatting If Cell Contains "Green" Put Mark "X" - Checklist

    hi all.... i need formula in Conditional Formatting to fill data form with criteria : If in cell contains-filled green color put/insert mark checklist "X" for detail form, i attachment that file... https://app.box.com/s/gta2hsathmm73sb6z9pytq2nru9nu5ch any help much appreciated.. m.susanto
  18. S

    Cell Status Change In Sheet1 Dependant Upon Lookup Value, and Reflects In Sheet2 - VBA May Be Required

    System: Windows 7 Professional 64-bit Software: Excel 2013 Greetings Everyone! I have been trying to manipulate snippets of code here and there to find a solution to this project. I wouldn't say that I'm a VBA novice, as I am not actively trying to code, rather than see what works from other's...
  19. C

    Dynamically create a checklist based on a matrix

    Hey folks. I'm looking to create a dynamic checklist based on the role ("user X" in the table below). The end result is to print off a sheet of paper for each user and verify each required step was complete, not all steps are required. I can get the data using INDEX (thanks Jonmo1 !). In the...
  20. J

    Procedure Too Large - Compile Error

    My code worked great until I finished it for 35 students. Now I get the procedure too large error, and I'm too much a novice in VBA for Excel to correctly figure this out. I have Sheet 1 that teachers will input a last name and a first name for each student. Student 1 starts on row 9 all the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top