Getting trouble making codes for the buttons and checkbox

Hello mariposa
Please see the attached I think it may meet most of your requirements.
I have modified your template slightly in a new Tab which I have called "Modified".
Using this, note the following points:
1. In Col J repeatedly click on your cells and it will cycle through "check", "NA" or blank. This will enable you to select thet cells you wish to set individually.
2. In cell C4 you can add to the vehicle makes by selecting the cell and updating the list from the main Excel menu: Data, Validation List, Source box
3. In cell C5 you must have the Calendar control installed. If you need further info see the link http://www.rondebruin.nl/calendar.htm
4. I am not sure what you require in cell C3, but again select the cell and update the list from the main Excel menu: Data, Validation List, Source box
Barry

OK mariposa

I now understand what you require andI have attached an updated workbook.

1. I have implemented a keypad in cell C3
2. I cannot notice any change in cells as you describe but I have made a small modification which may help. Please let me know.
3. I have also provide a Tab sheet called Vehicle List. This will allow you to add vehicles to this list and they will appear in the dropdown box in cell C4.
This will be easier for you to update and maintain.

The solution uses the Worksheet_SelectionChange event.
The code is provided in two places.
1. the Tab sheet "Modified".
To see the code open-up the VB editor and select "Sheet4 (Modified)" then right click and choose View code.
2. the Keypad userform.
Open-up the VB editor and select "TaskEntry" within the Forms folder list. Again right click and choose View code.

I hope this meets your requirement.
Barry

Hello Barry,

Thank you thank you for the quick reply. I have tried the new modified version that you made for me. and thank you for your kindness of guiding me what to do. i will try this one at work and let you know when its perfectly works. ..

if its not too much for me to ask, how will i put calendar button (like you did in C5 completion date) in J5 as well? If you have any idea, that would surely makes me happy.

but then again, thank you so so much for the help.

best regards,
mariposa

mariposa
in the attached I have:
.. included calendars (as requested in your other post) in cells J5, G8 and G9
(also acknowledgements to jaslake)
.. provided a facility to clear all checkboxes in col J (as requested in your other post) - click cell J6
All entries in col J were centred in the last update.
Since the last update I still do not have changes in other cells when updating col J.
Have you tested this in the last update?
If it is still a problem please upload the version you are using for me to check-out.
barry

WOW...THANK YOU THANK YOU SO MUCH BARRY! This last attachment you gave, is certainly PERFECT! thank you for your help.
I tried it at work and now its really working....its a great help for me. My 1st page of checklist is complete. Now im working on the last page, and Im copying your code for TaskEntry and Calendar but it seem not working for my Sheet1. I want to put same function LIKE in C5(you made on my 1st checklist) at cell D14,D15,D16 , D17 in this worksheet. and also, id like to have a calendar in D18. i really really try to copy what you did, but its midnight now and i got headache already still i didnt figure it out. So i decided, maybe when you have time for me again, you could help me with this. If i can complete this, my checklist would be AWESOME. and i will be grateful to you.if you open the attachment, i have made a code with Yes, NO, NA thing, dont be surprise coz i just copy and modify it too. it works for me though. but i dont know how to make a button that can clear, when i want, entries in cell H23 to J59 to be gone and do the same separately in cell K23 to M59. This are all i want...Hope you can still help me.

my first checklist is really good. I am so happy. Hope you will still help me with the last one.

PS. Sorry for my delayed reply. I cant get through the site yesterday, there's problem i guess.

best regards,
Mariposa

Hi mariposa
I am glad that your first checklist is good for you.

Please find attached an updated version of your second one.

As requested I have:
.. implemented a Calendar selection at cell D18
.. implemented a Keypad entry at cells D14, D15, D16, D17
.. allowed you a number of ways to clear your checklist columns
select Y, N, or N/A in row 21 and this will clear that column and leave everything else undisturbed;
select cell H20 and this will clear all the Designate columns in one go;
select cell K20 and this will clear all the Checker columns in one go.
This should give you maximum flexibility.

Barry

hi barry,

YES!! i thank you so much for the help...thank you..everything works!!! perfectly!!!

thank you thank you...

mariposa

Great!
If you are satified then please mark your thread as SOLVED.
Barry