Hi
I have this code and it is set windings 2. I want to have a "X" mark instead of a check mark.
Please tell me what I need to change. thank you.
![]()
Please Login or Register to view this content.
Hi
I have this code and it is set windings 2. I want to have a "X" mark instead of a check mark.
Please tell me what I need to change. thank you.
![]()
Please Login or Register to view this content.
Also,
I tried to merge O16-P17 but the code stop working.
Here is the revised code.
![]()
Please Login or Register to view this content.
I am trying to figure it out what is on the code. Target.Value = "P" is a checkmark so what is letter for X?
Target.Value = "O"
alternative, Marlett
Target.Value="r"
Last edited by protonLeah; 04-12-2019 at 12:41 AM.
Ben Van Johnson
Hi ProtonLeah,
"O" is what I was looking for.
What alternative, Marlett? I tried "r" but it is not the X.
Thanks.
The x is a little small. Can it make a capital letter X ?
Or maybe add a font size?
like with this one Target.Font.Bold = True
Thank you
I am attaching the file .
Thanks :o)
How about this.
![]()
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Hi Bakerman2,
I need the check mark in L10, L12, etc. and I will use this code (marlet) for the C8,C14,etc.
Hi Bakerman2
When I click the box to uncheck, the X stayed in the box. It supposed to check and uncheck the box.
thanks.
something like this.
And I like you Marlett font as an "X"
see attached.
![]()
Please Login or Register to view this content.
If Marlett "r" for bolded "X" then what is the bolded check mark?
For checkmark it's "b"
Oh ok.
For slight check mark on Windings 2 the letter is "P" but for the HEAVEY CHECK MARK what letter should I used or characters?
WingDings 1 and ChrW(10004)
Hi
Is this right? After I added it then when I click the box, the ChrW(1004) text is what shows in the box instead a check mark.
Also, If you can fix this section, please:
When I added this, it does not uncheck the box it is just stay in the box.![]()
Please Login or Register to view this content.
This is the original with a single range:
This is where I added more range cells:![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
And for the HEAVY CHECKMARK.
![]()
Please Login or Register to view this content.
Hi
Thank you to both of you. It did exactly what I wanted to achieved.
There is another issue that I came about with that is When I added the code in Thisworkbook and it had a problem with the X mark only. The check mark is no problem on it.
This is the code I added in Thisworkbook:
![]()
Please Login or Register to view this content.
Please see attachment.
Thanks :o)
Good morning
I was able to resolve this issue. I use the Windings Unicode for X mark.
Thank you to both of you and all the expert who's always there for all the people who's no experience with excel especially me :o) .... just a little.
Again, Thank you.
Good luck with your project and thanks for rep+.![]()
Hi Bakerman,
Thank you too. I do really appreciate all the help.
I've been thinking and I've been wanted to try this in some of my worksheet. I don't know if this is possible.
I wanted to add an images (3d box) and be able to click over it and the "x" or check mark appears. The worksheet will be protected.
If it's not possible, is there anyway to make the cell look like it? (See attachment).
Thank you.
Hi
Guess what? I merged a cell D to cell N and the colortab in this particular is not working.
![]()
Please Login or Register to view this content.
Last edited by RJ1969; 04-14-2019 at 06:25 AM.
Morning :o)
I attached the file which the merged cell D:N and other merged cell are skipping when you color tab it.
Thanks.
Oooops... one more issue came about.
While the sheet is protected, try to enter an item number in cell D and press tab keyor the enter key and the check box marked it which i don’t select to mark it that box.
I tried to search for a tab/enter to disabling it but it seems does not work. Maybe you have a better solution.
Is there a way to place a message box if the user try to use tab key or enter key “Pls. Use mouse pad to click box”
Something like this.
Thank you
...I merged a cell D to cell N...
The line:If Target.Count > 1 Then Exit SubCauses the macro to exit if more than one cell is selected.
Last edited by protonLeah; 04-14-2019 at 03:45 PM.
Hi
I took that part out and it look like it work.
After I enter the Item number, it jump to the check box and it automatically check mark the box. I am trying to figure it out to skip those boxes.
Thanks.
Last edited by RJ1969; 04-14-2019 at 04:04 PM. Reason: work
Do I really need this code in it?
If Target.Count > 1 Then Exit Sub
I am not sure how much important it is to be in it. Should I put it back?
Hello
I pretty much got everything I needed from my previous request.
Everything works fine until I almost achieved what I needed until I added a “RESET” button and I get the Run Time Error 13 (mismatch).
Can you please fix the code so I will be able to do a Reset Button.
Thank you in advance :o)
![]()
Please Login or Register to view this content.
Hi Bakerman2
Almost there :o)
I attached the file again.
When I click Reset button. The colortab stayed in a cell N10.
Please check. Thanks :o)
How about this.
![]()
Please Login or Register to view this content.
Hi Bakerman2
I think its perfect :o)
Although when it returns to cell J5, it shows white color instead yellow.
Do you think you can change the font in the message box Maybe Red font and the style? Is this possible? If not, no problem.
Thanks.
The moment I hit Tab-key colored tab disappears and never comes back.
How do you invoke it and whats the purpose ?
Font and Font style can't be changed in a MessageBox. You would have to create a userform with a Label and Buttons to achieve that.
Hi
The purpose is that wihen I hit the button Reset and it return to J5 cell and it should highlight the the cell and this will tell me or my user where the cursor is. Is like when you tab and it highlights the cursor every time u hit the tab.
I particularly like this settings because i have a little problem with my eyesight and it is easy for me to see and know where i am at in the position :o)
But if is no solution, it is ok. Because when i hit the the tab it still works.
About the font for the message box, I thought so. I kinda did my research in the net. Thanks for the findings.
Let me know if u a solution w the color tab in J5 but if none no worry.
Thanks (friend)
This should do it.
Hi Bakerman2
Yay!!!! I knew you will find a solution :o)
What did you do in order to work?
Thank you
Check Reset button code.
Ok.... :o)
Thank you so much and I do appreciate the time you gave to it.
Glad to help and thanks for rep+. Much appreciated.
Good luck with your project.![]()
Please...... I have a very last request with this project and hoping it is possible.
I just thought of it that maybe it is possible.
I want to be able to click the boxes for X mark and check mark although the cells are protected?
cells boxes protected:
C8,C14,C20,C26,C32,C38,C41,C44,L10,L12,L16,O16,F27,L27
Cells not protected:
J5, N10 and N12
Last edited by RJ1969; 04-16-2019 at 08:43 PM. Reason: boxes
The last one.
Hi
I have an issue with the colortab and also if I put a password and click the reset button it ask for the password. My user will not have the password.
Thanks
When I protected the worksheet with a password, I normally select “unlocked cells” and “format cell” in order. Will you be able to set it this way and still be able to Tick the box?
I promise this will be the end after this is solved :o(
Try this. Password is RJ1969.
Hi Bakerman2
I tried the worksheet you sent me. It is not exactly what I wish for but close enough :o( sorry.
When I press the enter key, it still passing all the boxes. This is what I am trying for my user to avoid to press the enter key and will accidentally to have a wrong check mark.
I want something for them to be able to use tab key and enter key but only in the unlock cell.
See the attachment. I have unlock all entire cells including all the boxes in the worksheets except J5, N10, N12.
If you press the enter key or the tab key, it only goes in the J5, N10, and N12 cells with a color tab. The color tabbing is good (I love it :o).
But if it's not possible to tick the box with lock cell, no problem my friend. I think I will stick in the old format if is not possible. But I am hoping it will work the way I have wish for. So let me know and I hope explain it very well since my English is not good as it is.
Thanks.
Not possible what you're after.
I know you are trying to create a dummy-proof sheet but you will have to educate your user to correctly use the sheet.
When there's human interaction there always bound to be margin for error. That's just the way it is.
Good morning :o)
Ok... I guess I'll just have to do that, just educate them. Like they said "it is what it is" :o)
Thank you for all the help! You're the best as always.
Again, Thank you.
I attached the file.
Hi Bakerman2,
Sorry to bother you again. I have been searching and I think I found the answer.
Remember the issue that I was having and I think I found something to make my worksheet work. This is just exactly what I was looking for.
All I just need is to fix two things on it.
1)
no color tab or when I press the tab key or the enter key on (J4,AI5,R38,U41,Q44), can you please a color tab on it.
2)
can you add a message box after J4 entry, maybe “Don’t forget to click box”.
Everything is good except those 2 things.
My reset button is good.
The check boxes when I click is good except when I am at the bottom to click the box it return to J4 cell and I have to scroll down to see if the box is being check. I keep scrolling down every time I click the box at the end of the page. After you click the box, it should offset 2 according in the code. If you can fix this is as well that will be great.
Thanks.
Hi Bakerman2
I was able to add the message box into it.
Minus -1 :o)
Hope you'll be able to fix the color tab in cell J4",AI5, R38, U41, Q44.
Here is the updated file with the the message box.
Thanks.
Last edited by RJ1969; 04-22-2019 at 05:22 PM.
Hi Bakerman
Any luck?
Hello RJ1969,
It can be done, but then you may loose the "Tab" order. Is that o.k. with you?The check boxes when I click is good except when I am at the bottom to click the box it return to J4 cell and I have to scroll down to see if the box is being check. I keep scrolling down every time I click the box at the end of the page. After you click the box, it should offset 2 according in the code. If you can fix this is as well that will be great.
How do you want it "Fixed"? what must it be changed to?Hope you'll be able to fix the color tab in cell J4",AI5, R38, U41, Q44.
Regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hi,
I don’t really want to lose the tab order.
I want to fixed the cells to have a color tab.
Let me clear or explain it well. The cells J4,AI5,R38,U41,Q44 should be white not gray color. If u press the tab and it goes to the cell then it should be yelow.
Let say you tab to R38 and this cell should be uellow not white.
Thanks
You are asking too many conflicting things. You want a fix above a fix above a fix.
Your SelectionChange-event kicks in 3 times for 1 run. In a normal workbook Tab and Enter also fires SelectionChange, in your file it doesn't anymore.
You end up at the top of the sheet because your SelectionChange code says to on every run. So you need to scroll down to look at Checkbox. Now you want a fix to overrule your SelectionChange code.
You cannot keep fixing 1 thing with another. Result is that nothing works properly anymore.
This needs to be thought over again from scratch to work properly.
Hi
Ok. I will try to start from scratch with a different method.
In the meantime I will use what I have although there is a bit of a issue.
Thank you all.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks