checklist

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...

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...

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...

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...

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...

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...

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...

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...

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 =...

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...

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...

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...

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...

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...

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...

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

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

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...

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...

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...